if formula

S

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.
 
D

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

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
 
Top