Count occurance of largest duplicate number in a single column ran
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,
|