Hi
You can do it using function sumifs
Share sample data in excel sheet if you need further help..
Cheers!!
ᐧ
On Fri, Jan 9, 2015 at 7:39 PM, Janani Rajagopalan uthr...@gmail.com
wrote:
I have the below data. I want to dynamically sum the Value column when the
CID and FID are the same and
I have the below data. I want to dynamically sum the Value column when the
CID and FID are the same and calculate value/total value.
Total Value = -3,000,000
Data Set
CID
FID Type Value 130358708 198733143 L -283296.27 123218808 700636266 L
-11094494.2 001973308 500381594 L -102677357
Hi Team,
I have attached one excel sheet in wich i need to set the formula for the
person for the entire week.i.e is if one person is working form Mon to Fri
it should mark 9:00 and when same person working on Sat Sun it shoud mark
the time as 12:00
Please help me on this
--
Join official
Hi Jocky,
Please find attached with solution.
Regards,
Anoop
Sr. Developer
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I have attached one excel sheet in wich i need to set the formula for the
person for the entire week.i.e is if one person is working
Hi Anoop,
There is No formula in the attached sheet, :(
On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hi Jocky,
Please find attached with solution.
Regards,
Anoop
Sr. Developer
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta jocky6...@gmail.com wrote:
Hi
please see if this helps...
On Fri, Jan 4, 2013 at 6:43 PM, jocky Beta jocky6...@gmail.com wrote:
Hi Anoop,
There is No formula in the attached sheet, :(
On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hi Jocky,
Please find attached with solution.
Regards,
Hi Jocky,
Formula's been written in validation rule which will restrict any entry
other entry except 9:00:00 for Mon-Thu and 12:00:00 for Sat - Sun.
Try to write something there, you'll get error prompting to enter valid
values.
On Fri, Jan 4, 2013 at 7:11 PM, ashwani agnihotri
Hi Jocky,
Made changes in sheet removing validation to show up the values there. Find
attached the updated one.
On Fri, Jan 4, 2013 at 8:38 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hi Jocky,
Formula's been written in validation rule which will restrict any entry
other entry except
Hi Jocky,
I have been given to simple way solution. Please find the
attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I have attached one excel sheet in wich i need to set the formula for the
Aamir,
Thx for both gr8 people. ( Norain / Aamir )
Rgds,
Iqbal Shaikh
On 17 March 2012 10:10, Aamir Shahzad aamirshahza...@gmail.com wrote:
Another soluction
Aamir Shahzad
On Fri, Mar 16, 2012 at 11:44 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
On Fri, Mar 16, 2012 at
Hi, Friends
Go through attachment, need your help for formula.
Thx Rgds,
Iqbal Shaikh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need
On Fri, Mar 16, 2012 at 3:32 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote:
Hi, Friends
Go through attachment, need your help for formula.
Thx Rgds,
Iqbal Shaikh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Another soluction
Aamir Shahzad
On Fri, Mar 16, 2012 at 11:44 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
On Fri, Mar 16, 2012 at 3:32 PM, Shaikh Iqbal iqbal.hp...@gmail.comwrote:
Hi, Friends
Go through attachment, need your help for formula.
Thx Rgds,
Iqbal Shaikh
--
Hello Team,
How do i rank only positive numbers. Plz help me on formula.
Example
Amount Rank
200 2
100 3
-50NA
10 4
-5 NA
3001
--~--~-~--~~~---~--~~
14 matches
Mail list logo