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
|