How to return a value from the range of cells with the most recent date.
I have a sheet like the one above for each of my 100 employees. I want to be able to run a report on all these 100 sheets such that I can see the most recent date of an employee review and what the expectations for the next period will be. I am trying to use row 6 (highlighted in yellow) as the row to pull the most recent date and expectations for next period. I have read the tutorials on index, match, collect, max etc and been able to get the most recent dates using the max function. But I have not been able to get the words from the expectations column using the any combination of the index match and collect to work. Can someone hlep?
Help Article Resources
Check out the Formula Handbook template!