EXCEL FORMULA

[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 A1109

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

thanks in advance

best regards,
suersh tp

 

[Don Guillett]

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

 

[Don Guillett]

Since you asked for the row number instead, use this
=MAX(IF(ISBLANK(A1:A10000),0,ROW(A1:A10000)))