Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include names in formula by picking up names from rows
I have created an excel formula with names in it.
I have created a set of names and I want to call the names given in the row through formula. 3 A B C D 4 123 4/12/09 4/16/09 HOLDAY1 =IF(AND(A4<"",(NETWORKDAYS(B4,C4,D4))2),NETWORKD AYS(B4,C4,D4)) here HOLIDAY1 is one among the list of holdays listed in a separate column. When I use the row number in the formula, it is not considering my name value. Is there way to include or call name through formula |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include names in formula by picking up names from rows
Dilip
Suppose you have the list of holidays in G1:G10 refer the range in formul as below =IF(AND(A4<"",(NETWORKDAYS(B4,C4,G1:G10))2),NETW ORKDAYS(B4,C4,G1:G10)) If you have named the range G1:G10 as holiday1 refer that as below =IF(AND(A4<"",(NETWORKDAYS(B4,C4,holiday1))2),NE TWORKDAYS(B4,C4,holiday1)) If this post helps click Yes --------------- Jacob Skaria "Dilip" wrote: I have created an excel formula with names in it. I have created a set of names and I want to call the names given in the row through formula. 3 A B C D 4 123 4/12/09 4/16/09 HOLDAY1 =IF(AND(A4<"",(NETWORKDAYS(B4,C4,D4))2),NETWORKD AYS(B4,C4,D4)) here HOLIDAY1 is one among the list of holdays listed in a separate column. When I use the row number in the formula, it is not considering my name value. Is there way to include or call name through formula |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include names in formula by picking up names from row
Oops I totally misunderstood your question..
-- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Dilip Suppose you have the list of holidays in G1:G10 refer the range in formul as below =IF(AND(A4<"",(NETWORKDAYS(B4,C4,G1:G10))2),NETW ORKDAYS(B4,C4,G1:G10)) If you have named the range G1:G10 as holiday1 refer that as below =IF(AND(A4<"",(NETWORKDAYS(B4,C4,holiday1))2),NE TWORKDAYS(B4,C4,holiday1)) If this post helps click Yes --------------- Jacob Skaria "Dilip" wrote: I have created an excel formula with names in it. I have created a set of names and I want to call the names given in the row through formula. 3 A B C D 4 123 4/12/09 4/16/09 HOLDAY1 =IF(AND(A4<"",(NETWORKDAYS(B4,C4,D4))2),NETWORKD AYS(B4,C4,D4)) here HOLIDAY1 is one among the list of holdays listed in a separate column. When I use the row number in the formula, it is not considering my name value. Is there way to include or call name through formula |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include names in formula by picking up names from row
Hi Jacob,
Thanks for your suggestion, but my intention is to use names listed (holiday) in a row and call those into my formula and drag the formula to the entire column. Actually indirect was working fine "Jacob Skaria" wrote: Dilip Suppose you have the list of holidays in G1:G10 refer the range in formul as below =IF(AND(A4<"",(NETWORKDAYS(B4,C4,G1:G10))2),NETW ORKDAYS(B4,C4,G1:G10)) If you have named the range G1:G10 as holiday1 refer that as below =IF(AND(A4<"",(NETWORKDAYS(B4,C4,holiday1))2),NE TWORKDAYS(B4,C4,holiday1)) If this post helps click Yes --------------- Jacob Skaria "Dilip" wrote: I have created an excel formula with names in it. I have created a set of names and I want to call the names given in the row through formula. 3 A B C D 4 123 4/12/09 4/16/09 HOLDAY1 =IF(AND(A4<"",(NETWORKDAYS(B4,C4,D4))2),NETWORKD AYS(B4,C4,D4)) here HOLIDAY1 is one among the list of holdays listed in a separate column. When I use the row number in the formula, it is not considering my name value. Is there way to include or call name through formula |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include names in formula by picking up names from rows
Hi,
Try this. =IF(AND(A4<"",(NETWORKDAYS(B4,C4,indirect(D4)))2 ),NETWORKDAYS(B4,C4,indirect(D4))) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Dilip" wrote in message ... I have created an excel formula with names in it. I have created a set of names and I want to call the names given in the row through formula. 3 A B C D 4 123 4/12/09 4/16/09 HOLDAY1 =IF(AND(A4<"",(NETWORKDAYS(B4,C4,D4))2),NETWORKD AYS(B4,C4,D4)) here HOLIDAY1 is one among the list of holdays listed in a separate column. When I use the row number in the formula, it is not considering my name value. Is there way to include or call name through formula |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include names in formula by picking up names from row
Hi Ashish,
Thanks a lot! now the formula working fine. Regards "Ashish Mathur" wrote: Hi, Try this. =IF(AND(A4<"",(NETWORKDAYS(B4,C4,indirect(D4)))2 ),NETWORKDAYS(B4,C4,indirect(D4))) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Dilip" wrote in message ... I have created an excel formula with names in it. I have created a set of names and I want to call the names given in the row through formula. 3 A B C D 4 123 4/12/09 4/16/09 HOLDAY1 =IF(AND(A4<"",(NETWORKDAYS(B4,C4,D4))2),NETWORKD AYS(B4,C4,D4)) here HOLIDAY1 is one among the list of holdays listed in a separate column. When I use the row number in the formula, it is not considering my name value. Is there way to include or call name through formula |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include names in formula by picking up names from row
You are welcome.
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Dilip" wrote in message ... Hi Ashish, Thanks a lot! now the formula working fine. Regards "Ashish Mathur" wrote: Hi, Try this. =IF(AND(A4<"",(NETWORKDAYS(B4,C4,indirect(D4)))2 ),NETWORKDAYS(B4,C4,indirect(D4))) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Dilip" wrote in message ... I have created an excel formula with names in it. I have created a set of names and I want to call the names given in the row through formula. 3 A B C D 4 123 4/12/09 4/16/09 HOLDAY1 =IF(AND(A4<"",(NETWORKDAYS(B4,C4,D4))2),NETWORKD AYS(B4,C4,D4)) here HOLIDAY1 is one among the list of holdays listed in a separate column. When I use the row number in the formula, it is not considering my name value. Is there way to include or call name through formula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Include Field Names | Excel Discussion (Misc queries) | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Picking names from a hat in Excel? | Excel Discussion (Misc queries) | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
how to put 'SUM' formula in VB after picking up certain names and their bonus | Excel Discussion (Misc queries) |