Thread: Extracting the most frequently occuring text from a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Extracting the most frequently occuring text from a range
What do you want if there is a tie ?
eg:

England
Germany
England
Scotland
Germany

--
AP

"Phil" a écrit dans le message de news:
...
I have five cells in a range filled with following:

England
Germany
England
Scotland
Wales

I want to return "England" being the country that appears the most. How
can
I do this?


Reply With QuoteReply With Quote