Counting categories
 

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.

Counting categories
 

Try this expression, array-entered** in a cell:
=INDEX(B6:B36,MATCH(MAX(COUNTIF(B6:B36,B6:B36)),CO UNTIF(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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tryn2learn" wrote:
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.