Can someone help me with this?
I have a vertical column with the dates for September. Everyday I enter a number for that days work. In another cell I want to show the most recent entry no matter what the number is. It doesn't matter if it's higher or lower I just need the last entry in the column.
Is there a formula for this?
Thanks
Try:
=Lookup(9.9999999e+307,A:A)
where A:A is the column you want to look at.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank You, very much that works!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks