View Single Post
  #5   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

Thanks for the helpful and quick responses. I got just what I was looking for.

globetrotter

"Teethless mama" wrote:

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