Title sums it up pretty much. I'm not seeing how to upload a sample file here but maybe this is simple enough. Suppose I have a column of data, numbers, that I add rows to daily in a table and I want a cell above the table to display the last value in the column. We'll say this is all in column A. How would I do this? Thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
how to point to last cell in range?
Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,464
- Office Version
- 365
- Platform
- Windows
Give this formula a try...
=LOOKUP(9.99999999999999E+307,A:A)
=LOOKUP(9.99999999999999E+307,A:A)
Upvote
0
