Forum Discussion
Solved
How to copy last entry
How do I copy the last entry in this column to another cell.
In C17:
=LOOKUP(9.9999999999999E+307, C3:C14)
Let's say the Checking Balance cell is C40. Enter the following formula:
=LOOKUP(9.9999999999999E_307, C1:C39)
Thanks for response. It isn't difficult to do it the way I do which is just copy/paste but I was wondering if when a new entry is inserted in the c3:c14 column that it will also populate c17
Using 365 you would also have XLOOKUP
= XLOOKUP(TRUE, ISNUMBER(data), data, , , -1)
In C17:
=LOOKUP(9.9999999999999E+307, C3:C14)
Excellent. Works perfectly. Could you explain the process?
