ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number count - postcodes and need to count the numbers of tim... (https://www.excelbanter.com/excel-discussion-misc-queries/51890-number-count-postcodes-need-count-numbers-tim.html)

Mark - Aust

Number count - postcodes and need to count the numbers of tim...
 
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

Gary''s Student

Number count - postcodes and need to count the numbers of tim...
 
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.
--
Gary's Student


"Mark - Aust" wrote:

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



All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com