most common number
 

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..

most common number
 

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)

"Jeff" wrote in message
...
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..