Thread: return text value found most frequently in a column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default return text value found most frequently in a column
Try this *none array entered*

=INDEX(A1:A367,MODE(INDEX(MATCH(A1:A367,A1:A367,), )))


"globetrotter" wrote:

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