Jane has attended:
Excel Intermediate course
Counts in a list
Hi There
I have 22360 post codes and I need to find out which are the top 30. How do I do this please?
Thanks Jane
RE: Counts in a list
Hi Jane
I'm assuming that you mean the top 30 most common/repeated postcodes.
The easiest way to identify them is to make a pivot table with the Postcode in both the ROWS and VALUES section.
Ensure the values is set to COUNT
This will display all postcodes and the number of times it has been repeated. You can then sort/filter the results to identify the values you want.
Regards
Dennis