Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Top 10 for each Item in column
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The most repeted item in a column? | Excel Discussion (Misc queries) | |||
how to add .12 cents to every item in a column | Excel Discussion (Misc queries) | |||
does item match any in column B | Excel Discussion (Misc queries) | |||
Counting item in a column | Excel Discussion (Misc queries) | |||
Returning the last item in column | New Users to Excel |