Data Tables

Resolved · Medium Priority · Version 2003

Wed 4 Mar 2009, 13:12 Delegate Renate said...

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?

Wed 4 Mar 2009, 13:16 Trainer Cress said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips