Excel lists

[Michael Duffy]

As I add daily numerical data to a list, I want the latest entry to appear in
an absolute reference cell. An example would be: I enter data in a range
(A1:A1000) and say I enter data in A260. I want the latest entry to appear in
cell $E$6, then the next day, data is entered in cell A261 and I want the
data in A261 to now appear in cell $E$6. How do I write this formula. Thank
you

[Leith Ross]

Hello Michael,

Assuming your lateset entry is the last one in Column "A", this code will place the latest entry into $E$6 on the worksheet named Sheet1. Change Sheet1 to the worksheet name you are using.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[excelent]

put in E6 and press CTRL+SHIFT+ENTER

=INDIRECT("A"&ROW(INDEX(A:A,LARGE(IF(A1:A1000<>"",ROW(A1:A1000)),1),)))