Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
get a range corresponding to a particular col header
I have a formula which takes a range argument (technically [array] according
to excel). I want to look up a particular col header and pass a range below it to the formula. Hence if a new col is added to the referenced table of data, the formula will always be referencing the correct range. Is this possible? The formula is quite long so it may be better to use some hidden rows or something to hold intermediate steps. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
get a range corresponding to a particular col header
Not sure of your issue, but it kind of sounds like you should check out the
Offset function. -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "PBcorn" wrote: I have a formula which takes a range argument (technically [array] according to excel). I want to look up a particular col header and pass a range below it to the formula. Hence if a new col is added to the referenced table of data, the formula will always be referencing the correct range. Is this possible? The formula is quite long so it may be better to use some hidden rows or something to hold intermediate steps. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
get a range corresponding to a particular col header
On Jul 1, 9:39 am, Gary Brown
wrote: Not sure of your issue, but it kind of sounds like you should check out the Offset function. -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "PBcorn" wrote: I have a formula which takes a range argument (technically [array] according to excel). I want to look up a particular col header and pass a range below it to the formula. Hence if a new col is added to the referenced table of data, the formula will always be referencing the correct range. Is this possible? The formula is quite long so it may be better to use some hidden rows or something to hold intermediate steps. Thanks Or possibly HLOOKUP. Maybe name some of your ranges if you haven't, to simplify formulas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I place Range text into a header? | Excel Worksheet Functions | |||
Date Range displayed in header | Excel Worksheet Functions | |||
use a range for a print header | Excel Discussion (Misc queries) | |||
Exclude Header from Range? | Excel Discussion (Misc queries) | |||
Using a named range in a header with VBA? | Excel Discussion (Misc queries) |