Returning Top Results

[Rosie]

I have a spreadsheet with a great number of rows of data.
I want to be able to easily tell who the top thirty users
of a service/product are. Can anyone help please.

 

[Dave R.]

Try the LARGE function. You can put the numbers 1..30 down a column (say
A1:A30), and in the next column put

=INDEX(E$10:E$14,MATCH(LARGE(F$10:F$14,A1),F$10:F$14,0))

and copy it down to cover all 30.
key:
E$10:E$14 would hold the customer's name
F$10:F$14 would be values of their total product use

don't forget the $ ...

 

[LEB]

Use Data...Filter...AutoFilter. Click the arrow on the
column that lists the product/service type, and choose
the product/service you're interested in. Then click the
arrow on the column containing the quantities
used/purchased, click the Top 10 option, and in the
dialog box change the value to 30

 

[Ken Wright]

Have you considered using a Pivot table to analyse your data - Eats this stuff
for breakfast

Nice intro here:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Aladin Akyurek]

For a formula-based approach, see:

http://www.mrexcel.com/board2/viewtopic.php?t=69999