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