Thread: return text value found most frequently in a column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
globetrotter globetrotter is offline
external usenet poster
  
Posts: 5
Default return text value found most frequently in a column
I have a column of text with 367 entries, author's names. I have used
SUMPRODUCT to determine that there are 267 unique entries. Is there a
formula I can now use to give me the author's name that appears most
frequently? Thanks for your help.

globetrotter
Reply With QuoteReply With Quote