Counts in a list

Resolved · Low Priority · Version 2016

Mon 24 May 2021, 15:42 Delegate 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:32 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips