I have the dates linked to another workbook and would like a formula to extract the highest visible month and year
I have attached sample data
It would be appreciated if someone could kindly assist me
I have the dates linked to another workbook and would like a formula to extract the highest visible month and year
I have attached sample data
It would be appreciated if someone could kindly assist me
You should be able to use the MAX function on that row.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
"E1"Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Hi Ali
Thanks for the reply
I tried Max before posting my query, but it does not give me the highest month and year-see attached sample
Thanks Atul
Your formula works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks