excelbytes
Active Member
- Joined
- Dec 11, 2014
- Messages
- 257
- Office Version
- 365
- Platform
- Windows
I need to find the last column that a certain person would appear. For example, in this table, I would want a formula that would result in 6/3/2024 for Person 2 (which is in cell I9. I used Power Query to unpivot the table then used MAXIFS to find that result, but was wondering if there was a formula way to accomplish this.