Formula to check cells and pull latest dates header (need modification)

[squeakums]

I have this formula that I created:

=INDEX($D$1:$S$1,MATCH(MAX(D1275:S1275),D1275:S1275,0))

It looks in these cells and finds the latest date and pulls the header. The issue is that there are two fields that have the same date because both instances were completed during the same day. I want this to pull the last - most recent date moving from left to right. For example in this field it has 6/8/21 and then 6/8/21.. but I want it to pull the 2nd 6/8/21 header. Do you know if this is something I can accomplish by editing my code?

Or, is there another code I can use.

Thanks.

 

[squeakums]

Thanks for that.
How about

=LET(f,FILTER($D$1:$S$1,MAX(D1275:S1275)=D1275:S1275,0),INDEX(f,COLUMNS(f)))

This one is causing a #NAME? error. I also tried with the ctrl,shift enter to see if this was that type of formula and same error. I don't understand the f,filter in the formula. Is there something else I am supposed to edit. Thanks again fluff

 

[Fluff]

You may not have the LET function, in which case you need to update Excel.
How about

=INDEX(FILTER($D$1:$S$1,MAX(D1275:S1275)=D1275:S1275,0),COLUMNS(FILTER($D$1:$S$1,MAX(D1275:S1275)=D1275:S1275,0)))

 

[squeakums]

You may not have the LET function, in which case you need to update Excel.
How about

=INDEX(FILTER($D$1:$S$1,MAX(D1275:S1275)=D1275:S1275,0),COLUMNS(FILTER($D$1:$S$1,MAX(D1275:S1275)=D1275:S1275,0)))

Okay, this one might work, trying it out for other fields. Thanks again Fluff you are the excel yoda master!

 

[Fluff]

Glad we could help & thanks for the feedback.

Please don't forget to update your profile, saves us having to ask.

 

[squeakums]

Glad we could help & thanks for the feedback.

Please don't forget to update your profile, saves us having to ask.

Thanks I have that updated now for my profile. Apparently, I need to make a quick edit on this to where it pulls the last date field updated moving left to the right D2:S2 (some fields aren't date fields in the array. Or in the cells D2, E2, G2, I2, L2, O2 and S2. Would you happen to know this formula please fluff?

 

[Fluff]

As this is now a significantly different question, it needs a new thread. Thanks