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?