Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
35
Views
Topic starter
Hello,
We do a review every 6 months, so I need a formula to constantly scan row F to find the last "Review" and display the corresponding date in column A into Cell N3.
Thank you.
Posted : 08/03/2024 1:34 pm
Hi,
You could try something like this in N3:
=INDEX(A:A,MAX((F8:F1000="Review")*ROW(8:1000)))
In this example I've limited the range to look for the word "Review" from F8 to F1000. You may adjust it to a range that suits your real data better, of course.
In case this doesn't work for you, come back here and upload your file so that we can come up with a better solution. and please mention the Excel version and platform (Mac or PC) you are working with/on.
Riny
Posted : 09/03/2024 2:42 am
Topic starter
Hello Riny,
Thank you. That worked perfectly!
Have a great day!
Stephen
Posted : 12/03/2024 9:20 am
