» Find the most commonly repeated string in a column in Microsoft Excel
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
In cells A1:A14, the following values appear
Enter the following formula in cell B1: =COUNTIF(A:A,A1) - copy the formula from cell B1 to B2:B14
The result:
Enter the following formula in cell C1: =INDIRECT(ADDRESS(MATCH(MAX(B:B),B:B,0),COLUMN(A:A)))
The Result: AAA
Enter the following formula in cell D1: =MODE(B1:B14)
The Result: 5
Book Store:
No comments have been submitted.
