EXCEL FORMULA

  • Thread starter Thread starter SURESH
  • Start date Start date
S

SURESH

Dear friends,

anyone can tell me which formula will help me to know which is the last
entered cell.

For example:
My data is A1:P109

so the formula should say the last entered row/cell is 109

thanks in advance

best regards,
suersh tp
 
try this array formula (entered with ctrl+shift+enter) for either text or
number
=INDEX(A1:A65535,MAX((ISNUMBER(A1:A65535)+ISTEXT(A1:A65535))*ROW(INDIRECT("1
:65535"))))
 
Since you asked for the row number instead, use this
=MAX(IF(ISBLANK(A1:A10000),0,ROW(A1:A10000)))
 
Back
Top