Row/Column 0 (zero) for titles

[jrskurbe]

A problem with some functions in Excel is if you include a title row/column,
you can't use functions like $A:$A, which are very useful if you have to
import varied data. Did Microsoft ever consider creating a "Row 0" or Column
"0" where you can add a title row but not have the formulas affected? I ran
into trouble with this when writing a combination HLOOKUP/MATCH formula.
Since HLOOKUP wants the first row of values in order, and the first row was
the titles, I was forced to place a range in the formula. Since I cut and
paste data frequently to analyze the data, named ranges aren't a good option
since I would constantly have to adjust them.

Please let me know what you think...

Thanks,
-Jason.

 

[Arvi Laanemets]

Hi

You can define your named ranged dynamic - so they will adjust automatically
whenever you add/remove rows or columns.