Re: Row/Column 0 (zero) for titles

From: Arvi Laanemets (garbage_at_hot.ee)
Date: 03/04/05 

Date: Fri, 4 Mar 2005 08:23:34 +0200

Hi

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

-- 
When sending mail, use address arvil<at>tarkon.ee
Arvi Laanemets
"jrskurbe" <jrskurbe@discussions.microsoft.com> wrote in message
news:C146F759-9B8D-49BC-A1BE-0C47F653D3F1@microsoft.com...
> 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.