Find MAX Column In An Array

[excelbytes]

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.

 

[excelbytes]

That means 1) there are no match or 2) your date headers are text and not date.

It works. The row of dates looked like dates, were formatted as dates, but weren't processing as dates. I re-entered them and it worked.