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

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))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

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

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


"samoan" wrote:

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