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!





2 Replies
best response confirmed by Hans Vogelaar (MVP)


You can try using a Pivot Table.

postal code.JPG


Thank you - that was sorted quickly!

Have a good weekend.