Picking up the last entry

[khank]

Everyday I have an entry on Worksheet 1.

Example: A110:4
On Worksheet in B1 - I would like that daily number to appear (4)

Isn't a formula to update automatically with last entry from Worksheet 1 Column A?

Thanks -

[jeffreybrown]

You could try...

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))

[mrice]

You could try something like..

Please Login or Register  to view this content.

pasted into B1. I have assumed that there are no gaps in the data in column A.

[khank]

I tried
=INDIRECT('SHEET 1'!"$D$ & COUNTA(D:D)) - there's a mistake in the code.
I even tried it by adding $D2$, still the same.

[khank]

I tried
=INDIRECT('SHEET 1'!"$D$ & COUNTA(D:D)) - there's a mistake in the code.
I even tried it by adding $D2$, still the same.

[NBVC]

=LOOKUP(9.99999e+307,A:A)

should get you the last numerical entry in column A

FYI.. you have the quotes in the wrong place in that formula you posted.

s/b: =INDIRECT("'SHEET 1'!$D$" & COUNTA(D:D)) but that won't necessarily work, as it relies on you starting at D1. It counts how many entries are in column D and makes that the row reference to match. So if you have entries in D3 and D4 and expect the result to show what is in D4, it won't because it counts 2 entries in column D and so applies Sheet 1!D2 as the lookup cell and will probably return 0.

[khank]

Thanks the code is working - for some reason I was thinking I needed to pick the code on a different sheet. I needed to keep it on the original sheet then do a "cell" copy to the sheet I needed the number at.

Thanks to you all! Happy Holidays.