Counting categories

[tryn2learn]

Is it possible to get an average on the number of times a category appears
within a range.

my categories are
ENC L
NB ENC
V ENC
ALL CL

i want to get the average of the most requested category over 1 month. the
range i am using is would be B6:B36

thank you for your help.

 

[Max]

Try this expression, array-entered** in a cell:
=INDEX(B6:B36,MATCH(MAX(COUNTIF(B6:B36,B6:B36)),COUNTIF(B6:B36,B6:B36),0))

**Copy n paste the above into a formula bar, say in C2,
then press CTRL+SHIFT+ENTER to confirm the formula
instead of just pressing ENTER

Should there be any ties in the max, the expression will return only the 1st
instance.