MAX formula and Conditional Highlighting of 1st instance of a duplicate value

[MdPreez]

Hi All,
I hope you can help? I am quite desperate!

I need to highlight only the 1st instance of MAX value in a row over 5 columns.

IE: A1:E1 with the values being:
7; 7; 5; 6; 3.

I want to highlight ONLY ONE/THE FIRST instance of the 7.

What do I need to add to the formula (which highlights both cells with 7 in it) below to make that happen?
=A1=MAX(A1:E1)

Thanks

 

[Fluff]

Hi & welcome to MrExcel.
Try

=AND(A1=MAX($A1:$E1),COUNTIFS($A1:A1,A1)=1)

 

[MdPreez]

Hi & welcome to MrExcel.
Try

=AND(A1=MAX($A1:$E1),COUNTIFS($A1:A1,A1)=1)

Awesome!
Can this also be applied to the Top ranked formula where there is a duplicate?
IE: If I use Top 1 ranked

 

[Fluff]

What is the formula?

 

[MdPreez]

N

What is the formula?

Never mind, I don’t think I need to use the Top ranked formula anymore!
Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[MdPreez]

You're welcome & thanks for the feedback.

Hi, I have a follow-up question regarding the highlighting.

Your solution for my initial questions works like magic. Now, I am trying to do the following ons the same data, so:

A1:E1 with the exact same value of
6,0; 6,0; 6,0; 6,0; 6,0

Your formula accurately highlights the 1st instance!
=AND(A1=MAX($A1:$E1),COUNTIFS($A1:A1,A1)=1)

I NOW need to have 2 of these cells highlighted if ALL cells are the exact same value.
The reason for this is to id the 2 highlighted cells, of the 5, that will not be calculated.

Hope this makes sense!
Thank you.

 

[Fluff]

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