HELP! Looking to Note Duplicates in INDEX-Match Formula

[gregz123]

Hello Mr. Excel team,

Below is a summary of weekly book sales by sales rep, to a range of 11 school. The goal is note the highest sales school(s) by rep (which I'd like to note in the winner column (M).

I currently have an INDEX-MATCH formula populating in the winner column that reads: =IFERROR(INDEX(PCT,MATCH(MAX(B2:L2),B2:L2,0)),"")

There are instances however where duplicate totals are noted, and excel is only capturing the earliest school #.

Question: How can duplicate total be noted in the winner column? And/or how can they be noted best in a separate column?

Thank you!

 

[gregz123]

Bumping up for any feedback.
Thank you!

 

[Peter_SSs]

Is this what you mean?
Select M2 down to end of data -> Conditional Formatting -> Highlight cell rules -> Duplicate values ... -> OK

22 10 16.xlsm
	M
1	Winner
2	School 2
3	School 3
4	School 2
Duplicate Winners

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
M2:M4	Cell Value	duplicates	text	NO

 

[gregz123]

Is this what you mean?
Select M2 down to end of data -> Conditional Formatting -> Highlight cell rules -> Duplicate values ... -> OK

22 10 16.xlsm
	M
1	Winner
2	School 2
3	School 3
4	School 2
Duplicate Winners

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
M2:M4	Cell Value	duplicates	text	NO

I was looking for a means to flag the duplicates in column M, that would be found in B through L

 

[Peter_SSs]

I was looking for a means to flag the duplicates in column M, that would be found in B through L

Then perhaps you could provide some sample data and expected results with XL2BB and explain again in relation to that sample data?

From what you showed before, you have highlighted the 10 values in D4 and F4 but they are not the maximum values in the row so I am not sure how/why you would be wanting to flag those under the "Winner" column.