Assume your numbers are in the range A1:A10

=LOOKUP(1E100,A1:A10)

--
Biff
Microsoft Excel MVP


"samoan" wrote in message
...
have column of numbers. at bottom of column, want cell to display last
number
in column. can't use max cause last number may be less than number above.
could use =if but can't next more than 7 formulas. possibility of 30
numbers
in column.


--
Tx,
Samoan