Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtotaling with Counting - not sure how to phrase this one...
I have a lists of customers in Excel that includes address and zip code.
Is there a way for Excel to list each zip code and how many customers in each? So if I had: 75024 75024 75093 75093 75093 75248 That at the bottom of the list I would have: 75024 - 2 75093 - 3 75248 - 1 Thanks! -Steve |
#2
|
|||
|
|||
Hi
Pivot table does what you need. Arvi Laanemets "Steve R" wrote in message ... I have a lists of customers in Excel that includes address and zip code. Is there a way for Excel to list each zip code and how many customers in each? So if I had: 75024 75024 75093 75093 75093 75248 That at the bottom of the list I would have: 75024 - 2 75093 - 3 75248 - 1 Thanks! -Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting... | Excel Worksheet Functions | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions | |||
counting | Excel Worksheet Functions |