I need to know how to find out what the last cell entered was?
D Domenic Sep 26, 2005 #2 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!
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!
J JE McGimpsey Sep 26, 2005 #3 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?
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?
