most common number

[Jeff]

I have created a sheet that reports incidents in my work place, I need
to be able to report if a particular number ( employee indentified by
number) occurs more than once in column and identify "top ten" as in
frequency to another column or sheet.
Thanks in advance
Jeff..

 

[Bob Phillips]

Here is a formula that Harlan Grove posted a while back

=INDEX(RNG,MATCH(LARGE(FREQUENCY(RNG,RNG)
+(1-ROW(INDIRECT("1:"&(ROWS(RNG)+1)))/(ROWS(RNG)+1)),ROW()),
FREQUENCY(RNG,RNG)
+(1-ROW(INDIRECT("1:"&(ROWS(RNG)+1)))/(ROWS(RNG)+1)),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter, and copy down

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)