Ranking spreadsheet

[marino3d]

Hi,

I have a spreadsheet with 2 columns of data. Column A contains thousands of zipcodes. Column B contains a value for each zipcode that can be denoted as 1000,2000,3000 all the way up to 18000. What I need to find out is what is the top 3 zipcodes in total wealth. Here is some sample data to illustrate this:

10001 2000
10001 5000
10001 3000
10001 6000
10002 12000
10002 5000
10003 18000

So in this example 10001 would be last place with a total worth of 16000,
10002 would be 2nd with 17000 and 10003 would be 1st with 18000. In the real spreadsheet though there would be thousands of zipcodes and I'm only interested in the top 3 total value. Any ideas?

 

[crook_101]

Hi,

Probably the easiest way would be a pivot table using zip code as a row label and the monetary values under values in the PT.

You would be able to sum the data and get an instant answer.

Reagrds,
Ian

 

[marino3d]

Hi,

Probably the easiest way would be a pivot table using zip code as a row label and the monetary values under values in the PT.

You would be able to sum the data and get an instant answer.

Reagrds,
Ian

That did it. Never used a pivot table before but that helped. Thanks!

 

[crook_101]

No worries.

Pleased you are sorted and thanks for the thanks

Ian