Tag Archives: mode

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 … Continue reading

Posted in Spreadsheets | Tagged , , , , , , | Leave a comment