I have a workbook built for my company that uses index match to return the subject line of a employee communication. However if there are multiple communications the formula only returns the first entry. What can I use to return the subject line based on the most recent date? There is an additional column that contains the date that the communication was sent.
This is the data I am using:
Quality & Service
DSAT - 3/8 - Discussion - Call not ava - 1/16/2019
DSAT - Disscussion - Verbal - Skill
I want to return the Subject based on the most recent entry in Created.
I am currently using this formula to pull the data: