Returning Top Results

  • Thread starter Thread starter Rosie
  • Start date Start date
R

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