software

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 quot;top tenquot; 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(quot;1:quot;amp;(ROWS(RNG) 1)))/(ROWS(RNG) 1)),ROW()),
FREQUENCY(RNG,RNG)
(1-ROW(INDIRECT(quot;1:quot;amp;(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)

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