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