Forum Discussion

Pat_B1400's avatar
Pat_B1400
Copper Contributor
Nov 04, 2022
Solved

Filters In Excel

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

Resources