Win/Loss Formula Based on Highest Number in each Row

For C20 (Blue Win Cell) to count a Win

Cell C2 (Blue 2.3 Cell) has to be

Greater than the other colored cells (C-G Row 3) Horizontal to it

Else it should calculate as a loss

at cell C21


Example:

For Blue to be a win:
The Orange, Yellow Purple, Red (Horizontal to Blue)
Must individually be less than Blue

For Orange to be a win:
Blue, Yellow, Purple, Red (Horizontal to Orange)
Must individually be less than Orange

For Yellow to be a win:
Blue, Orange, Purple, Red (Horizontal to Yellow)
Must individually be less than Yellow

For Purple to be a win:
Blue, Orange, Yellow, Red (Horizontal to Purple)
Must individually be less than Purple

For Red to be a win:
Blue, Orange, Yellow, Purple (Horizontal to Red)
Must individually be less than Red

For the example in the spreadsheet Column E (Yellow) Should count the win from Row 3 to cell E20 because it has the highest number within the row it is in

Test_01.xlsx

I did post at the below forum but for some reason someone thought it was a duplicate but was not. (Update: it was because it was crossed posted without reference as I was unaware of the requirement but is still locked out).
It is a request for a new formula based on different criteria for how the data needs to be grabbed, sorted, and calculated

Please Login or Register  to view this content.

Sorry for the code wrap but the forum will not allow links since I just joined.

I think this is what you want.

The formula in column J finds the column position of the winning color. It does not break ties. It finds only the first of the highest score.

Then the wins / losses are calculated with countifs formulas.

That works great, thank you!