Last cell entered
 

I need to know how to find out what the last cell entered was?

For the last entry...

=LOOKUP(2,1/(1-ISBLANK(A1:A100)),A1:A100)

For the cell address of the last entry...

=CELL("address",INDEX(A1:A100,LOOKUP(2,1/(1-ISBLANK(A1:A100)),ROW(A1:A100
)-ROW(A1)+1)))

Hope this helps!

In article ,
"kyjilly" wrote:

I need to know how to find out what the last cell entered was?

Your post is a bit ambiguous. By "last cell entered" do you mean:

a) the last cell in a list (e.g., column or row)
b) the last cell selected
c) the last cell in which a value was changed?
d) something else?

In article ,
"kyjilly" wrote:

I need to know how to find out what the last cell entered was?