How to find the most frequent text value in a spreadsheet column

Here’s a compact solution to find the single most frequent value:

=INDEX(A2:A6,MODE(MATCH(A2:A6,A2:A6,0)))

If entered into cell A1, this will display the value that appears most frequently in the range A2:A6 (see column A below).

Note: In a situation where more than one value appears equal-highest, the value that was counted last will be provided as the result (see column B above).

This entry was posted in Spreadsheets and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


*