Renate has attended:
Excel Advanced course
Data Tables
How do I count the number of individual different entries in a spreadsheet? For example I have a spreadsheet that lists all of the customer's address details for a product and I want to know what region has the most customers - please can you help?
RE: Data Tables
Hello Renate
Thank you for your question
I would use a Pivot table. Create one by clicking on a new tab and going data, Pivot table and chart. Follow the wizard to set up a Pivot table. It sounds like you will need to place the region column on the left box and the CustomerName/ID in the data field. Once this is done you will need to double click the grey arrow box and choose Count from the list as the default will be sum. PLay around with it and if you get stuck let us know.
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
