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
|