View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
catpro catpro is offline
external usenet poster
 
Posts: 2
Default 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,