if formula

[samoan]

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.

 

[Don Guillett]

try this where you are trying to match any number larger than possible in
your data.
in cell b31
INDEX(B1:B30,MATCH(99999999,B1:B30))

 

[T. Valko]

Assume your numbers are in the range A1:A10

=LOOKUP(1E100,A1:A10)

 

[Ron Coderre]

With values in A2:A100

This formula returns the last numeric value in that range:
=LOOKUP(10^99,A2:A100)

...or...if there may not be any numbers...this formula has an error check:
=IF(COUNT(A2:A100),LOOKUP(10^99,A2:A100),"")

Does that help?
***********
Regards,
Ron

XL2003, WinXP