Top 10 users formula

[niyazb]

How I can count top 10 or 20 users in worksheet contains 700 to 100
records? if am having 300 users are entered in the worksheet

I can do it by counting with count formula and sort the records in th
ascending order however this a bit long way and boring too I need t
get top users by just one calculation and without sorting

 

[Frank Kabel]

Hi
If I understopod your question correctly you want to count the number
of rows per user and create a top 10 list (that is the user with most
rows at the top)
one way: use a pivot table on your data. for some instructions how to
use this have a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Niek Otten]

=LARGE(YourTable,1)
=LARGE(YourTable,2)
etc.
Easiest is to create a column next to this formula, witt the numbers 1 to 10
and use that instead of 1, 2, etc
Do think about what you want to happen with equal numbers

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel