SOLVED

Filters In Excel

New Contributor

Hello All,

 

I have a list of 7k records with the postal area for each record in a single column.

 

I have added a Filter so I can view how many records there are in each postal area I.e AB = 21 records, AL = 7 records etc. 

 

I want to produce a summary table of how many records are in each postal area but as I have over 70 postal areas I was wondering if there is a quicker way of producing a summary count for each postal area?

 

Thank you in advance!

 

Regards,

 

Pat

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Pat_B1400 

You can try using a Pivot Table.

postal code.JPG

 

Thank you - that was sorted quickly!

Have a good weekend.

Pat