Filters In Excel

[Pat_B1400]

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 · Accepted solution]

@Pat_B1400 

You can try using a Pivot Table.

[#3]

Thank you - that was sorted quickly!

Have a good weekend.

Pat