find last row in a column of numbers

[my911]

i recall using hlookup with a large number but can’t figure out how

[Pete_UK]

I think you mean something like this:

=LOOKUP(1000000,A:A)

It will return the number that is in the last cell in column A. The value 1000000 is just a large number - it must be larger than any number which is likely to exist in column A.

Hope this helps.

Pete

[bill k]

enter in A1 or any other cell......... =SUMPRODUCT(MAX(($A$2:$A100000<>"")*(ROW($A$2:$A100000)))) to give you the row number of the last cell with a number. Found this one in a google search. Assumption: not more than 100,000 rows.

regards
Bill K New Zealand