Return any customized text for the highest value in a column

[alonc1983]

I’ve been trying to check the consition but unsuccessful. Instructions are in the attached spreadsheet.

 

[vletm]

alonc1983
As You've read that
Post an Excel related Challenge for others to Solve (You must have a solution) Don't post questions here!

 

[shrivallabha]

I’ve been trying to check the consition but unsuccessful. Instructions are in the attached spreadsheet.

If you have access to TEXTJOIN function then you can try approach as provided in attached workbook.
In cell I2,
=TEXTJOIN("-",FALSE,C2:G2)&"_R"&H2
In cell J2 (which you can implement in A2),
=IF(B2="CLD","CANCELLED",IF(TEXT(MAX(IF($C$2:$C$15=C2,IF($D$2:$D$15=D2,IF($E$2:$E$15=E2,IF($F$2:$F$15=F2,IF($G$2:$G$15=G2,$H$2:$H$15+0,-1),-1),-1),-1),-1),-1),"00")=H2,"NEW","SUPERSEDED"))
You may have to CTRL+SHIFT+ENTER if you are not on Office 365.

 

[alonc1983]

If you have access to TEXTJOIN function then you can try approach as provided in attached workbook.
In cell I2,
=TEXTJOIN("-",FALSE,C2:G2)&"_R"&H2
In cell J2 (which you can implement in A2),
=IF(B2="CLD","CANCELLED",IF(TEXT(MAX(IF($C$2:$C$15=C2,IF($D$2:$D$15=D2,IF($E$2:$E$15=E2,IF($F$2:$F$15=F2,IF($G$2:$G$15=G2,$H$2:$H$15+0,-1),-1),-1),-1),-1),-1),"00")=H2,"NEW","SUPERSEDED"))
You may have to CTRL+SHIFT+ENTER if you are not on Office 365.

This really works and I really appreciate it a lot. You are so helpful.