most common number

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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..
 
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)
 
Back
Top