last entry done in certain area
 

Dear friends..

i want your help regarding this subject.. can anyone help me?

actually, i have a big database in excel.. dont want to go last and first...
i want to know in certain cell (B1) which is the last entry had done in A:A.

i will prefer any formula..

thanks in advance


suresh tp

last entry done in certain area
 

If column A is of numeric type:

=LOOKUP(9.99999999999999E+307,A:A)

If column A is text-typed:

=LOOKUP(REPT("z",255),A:A)

SURESH wrote:
Dear friends..

i want your help regarding this subject.. can anyone help me?

actually, i have a big database in excel.. dont want to go last and first...
i want to know in certain cell (B1) which is the last entry had done in A:A.

i will prefer any formula..

thanks in advance


suresh tp