How to select the last filled row

[dara]

Hi,
I have a column of data and I add rows every day to that column; I just want
to see the data in the last row in another cell... whats the formula for
that???? ex: I have A12 which reads 48 as the last data on the column A; but
next week I'll have A43 and the data will be 84... I want a cell which shows
48 today and will show 84 next week....

PS: I managed to get a formula which shows the number of the last row but i
can't use it either... ex: the data I'm interested in, is in A12 and it reads
"48".... but tomorrow it will be in A13 and will be "52"; so I have a formula
which says "12" or "13" but I can't extract the "48" or "52" (so if the formula
I managed is in say "C4", I'd need something like "=A(C4)......" which will
give A12 or A13 and since A12 reads 48 (A13 reads 52), I will have 48(or
52).......

thanx

 

[JE McGimpsey]

One way:

Assume your data starts in A6 and continues without blanks in subsequent
rows:

=OFFSET(A6,COUNTA(A6:A65536)-1,)

 

[Guest]

Thanks,
but I made copy paste and it doesnt work.... my data starts at N3 and goes
without blanks....
=OFFSET(N3,COUNTN(N3:N65536)-1,) that's what i put in... it says
"name???" did I do anything wrong?
thanks again

 

[Guest]

OK i managed, I just got rid of "n" after the count...
so now it reads:
=OFFSET(N3,COUNT(N3:N65536)-1,)... I think thats correct...
thanx very much

 

[JE McGimpsey]

Try

=OFFSET(N3,COUNTA(N3:N65536)-1,)

 

[Guest]

When I put COUNTA it stays blank.... I think
=OFFSET(N3,COUNT(N3:N65536)-1,) is correct right?

 

[JE McGimpsey]

If your values are all numeric, COUNT() is sufficient. COUNTA counts
both numeric and text entries. Sounds like you perhaps have space or
other non-printing characters in your column that makes COUNTA > COUNT.