Top 25

[David French]

I have a user that has a LARGE amount of raw data.
What I see as a roundabout way of getting the top 25 was:
Apply subtotals
Viewed subtotals (level 2)
Copied Visible cells to another sheet

Doing this cuts the ties to the address information in the original sheet.
How can this be done against the original information?

Dave French

 

[Debra Dalgleish]

You could do this with a pivot table. There are instructions in Excel's
Help, and Jon Peltier has information and links:

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

For example, to get top 25 customers, put customers in the row area, and
sales in the data area.
Right-click the Customers button
Choose Field Settings
Click the Advanced button
For 'Top 10 AutoShow', select On
Set Show to Top 25
Click OK, click OK