Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

counts list

ResolvedVersion 2016

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

Excel tip:

Large Icons on toolbar

You can make the buttons on your toolbars bigger by going to Tools / Customize / Options / select Large icons.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.