Formula for value in a column that appears in the highest row number
I am chasing a formula for the most recent value in a column. ie highest row number.
Row A B ........F
1 100 (insert formula)=76
2 56
3 25
4 98
5 587
6 76
7
8
9
And if were to add another value
Row A B ........F
1 100 (insert formula)=367
2 56
3 25
4 98
5 587
6 76
7 367
8
9
Can anyone help?
Last edited by Matt Chis; 01-20-2011 at 10:32 PM.
Hello & Welcome to the Board,
How about...
=LOOKUP(9.99999999999999E+307,A:A)
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
Excellent Thank you
You're very welcome
If you are satisfied with the answer provided, please don’t forget to mark the thread as solved.
How to mark a thread Solved
Go to the first post
Select
-- Edit
-- Go Advanced
-- Below the word Title you will see a dropdown with the word No prefix
-- Update to Solved and then select Save
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks