|
|
| Lookup
the Most Frequently Occurring Value |
The following formula returns the most frequently occurring value from
B2:B10...
=INDEX(B2:B10,MATCH(MAX(COUNTIF(B2:B10,B2:B10)),COUNTIF(B2:B10,B2:B10),0))
| Note
that this is an array formula, which needs
to be confirmed with
CONTROL+SHIFT+ENTER for the PC or COMMAND+RETURN for the Mac. |
Based on the sample data, the formula returns B. Sample
Workbook
|
|
|
