User Profile
Jbowyer86
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
index match with multiple dates
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: CommID EmpID EmpName Category Subject Viewed Created 7.72E+08 2214626 Doe, Jon Quality & Service DSAT - 3/8 - Discussion - Call not ava - 1/16/2019 1 1/16/2019 21:59 7.63E+08 2214626 Doe, Jon General DSAT - Disscussion - Verbal - Skill 1 12/25/2018 22:33 I want to return the Subject based on the most recent entry in Created. I am currently using this formula to pull the data: =IFERROR(INDEX(KPICommDetail[Subject],MATCH([Ident],KPICommDetail[EmpID],0)),"") Help and thanks!!2KViews0likes3Comments
Groups
Recent Blog Articles
No content to show