Number count - postcodes and need to count the numbers of tim...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database of 15000 customers postcodes - I need to know the number of
customers per code - how do i count the number of repeated codes
 
One very easy way is to use a pivot table. Pull-down Data > Pivot Table and
follow the wizard. Put postcodes in the row area and count of postcodes in
the data area.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Postcode counting 4
Formula to count cell text by value 13
conditional pivot table??? 1
Counting the number of different entries in a column 2
Count If 2
Substitue for the IF Function 6
Postcodes starting with 0 4
Find and TRansfer from another Tab in same Worksheet 3

Back
Top