Skip to content
Home
Tutorials
Real-World Examples
Count most frequently occurring text
Update Formula
Parameters
Formula
Range:
Formula:
{=
COUNTIF
(
B5:B9
,
INDEX
(
B5:B9
,MODE(
IF
(
B5:B9
<>"",(
MATCH
(
B5:B9
,
B5:B9
,0))))))
}
{=
COUNTIF
(B5:B9,
INDEX
(B5:B9,MODE(
IF
(B5:B9<>"",(
MATCH
(B5:B9,B5:B9,0))))))
}