98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Counts in a list
Counts in a list
Resolved · Low Priority · Version 2016
Mon 24 May 2021, 15:42Delegate Jane said...
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
Mon 24 May 2021, 17:32Trainer Dennis said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Creating charts in Excel 2010Here's how to present your data in a chart format: |
