Select last data in column for a graph

  • Thread starter Thread starter ASTDan
  • Start date Start date
A

ASTDan

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
 
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)
 
It's not inconceivable that someone would have numbers greater than 9^9. The
largest number Excel can understand is something line 9.999E307, so I
usually hunt for 1E300.

- Jon
 
Back
Top