Last cell entered

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Msgbox runing beyond posted cell range. 1
Excel Message box called if 1 of 3 options is entered. 4
Excel Need assistance with modifying a Duplicate declaration. 13
Entering changing months with a cell 10
Excel Macro to automatically go to the right of the last colored cell 0
Last Modified By in a cell by user 3
Identifying the last visit 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top