hi,

This gets the last non-blank number
=LOOKUP(9^9,C3:C21)
This gets the last non blank text entry
=LOOKUP(REPT("z",255),B2:B21,B2:B21)
and this gets the last non-blank row number
=MAX((A1:A15<"")*(ROW(A1:A15)))
This needs to be array entered (press Shift+Ctrl+Enter to enter it)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"ASTDan" wrote:

Hello,

Is there an excel function that I can use to select the last cell that
contains data to display in a chart? Do I have to write a macro for this?

Thanks

Dan