Let's see if I understand what you want correctly.....

With
A1:A6 containing your posted data

You want to determine the largest value that is duplicated and flag cells
that match that value as "TIE"....even if another single occurring value is
larger.

If that is correct then
B1: =IF(A1=MAX(INDEX((COUNTIF($A$1:$A$6,$A$1:$A$6)1)* $A$1:$A$6,0)),"TIE","")

Copy that formula down through B6

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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,