=IF(A1=MAX(($A$1:$A$6)*(COUNTIF($A$1:$A$6,$A$1:$A$ 6)1)),"TIE","")


"catpro" wrote:

I need to count the occurance of only the largest duplicate number in a range
and return "TIE" in cells adjacent to those cells that have the largest
duplicate number.
Example
A B
1 ""
2 ""
5 TIE
3 ""
5 TIE
5 TIE

COUNTIF provides desired output but it's output provides "TIE" for all
matching cells without respect to the largest number.

Thanks,