Forum Discussion
Pat_B1400
Nov 04, 2022Copper Contributor
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
- OliverScheurichGold Contributor
- Pat_B1400Copper ContributorThank you - that was sorted quickly!
Have a good weekend.
Pat