Please Help: Adding an equation to a range

[tobriant]

Is it possible to add an equation to a range of data? For example, I a
using the MATCH function to return the row number of a last value in
specific column.

=MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)

I would like to use this row number to establish a named range tha
will adjust as a given set of data changes. For example, if the formul
returned 100, I need the named range to be A1 to K100.

Any different methods or suggestions

 

[RagDyer]

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================