Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I am using formula, {=SUM(IF($B$66:$B$200=A28,$D$66:$D$200))} But what if I don't know the coulmn number, i.e. 'D' In my source file values which I want to retriev are not always in D column, it could b E or F and evry time I don't want to update my formula... Coloum Header is always same but not column number. Is ther any way to retreive column number by using column header and then use that in above array formula? Please advise -- Milind |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MATCH an unknown number | Excel Discussion (Misc queries) | |||
Unknown number format | Excel Worksheet Functions | |||
Formula's dealing with unknown number of rows | Excel Discussion (Misc queries) | |||
Dividing by unknown to get a number | Excel Worksheet Functions | |||
How to Calculate an unknown number? | Excel Worksheet Functions |