Thread: Extracting the most frequently occuring text from a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phil
 
Posts: n/a
Default Extracting the most frequently occuring text from a range
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