I wonder if he needs to worry about the limit on number of items in a pivot
table (8000, IIRC).

Do you know how that limit is calculated? Is it the number of cells in the
data area, before filtering for the "Top N"?



"Dana DeLouis" wrote in message
...
A Pivot table sounds like a good solution to me. Drag the "Country" and
then "Amount" to the "Row" area. One suggestion is to drag "Amount" to the
"Data" area and change it from "Sum" to "Count." (just a way to see how
many are tied for the top spot).

In your Pivot Table, double click the "Amount" heading, then select
"Advanced", Select to Sort in descending order, and select to show "Top
10 Items."

If you have a lot of data, select the Pivot table options, and uncheck
"Save data with table layout" if you wish to store the file as a smaller
size.
HTH.
--
Dana DeLouis
Win XP & Office 2003


"Tod" wrote in message
...
I've been trying to do this with autofilter, but I think
now it's going to require greater thinkers than I.

I have two columns. The first is a list of country codes.
The second is amounts. There are many, many amounts and
so there are also many, many instances of country codes.
What I want to know is the top 10 highest amounts for
each country code. So if this is the list:

Country Code Amount
UK 123
US 22
FR 225
BE 101
IT 200
UK 15
UK 3
UK 112
IT 125
BE 234
BE 256
IT 751
FR 52
FR 68
FR 85
FR 885
......etc

This list goes on for about 15,000 rows. I want to find
out the top 10 highest Amount for each Country Code. How
could I do that?

tod