Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
do i use countif?
Am using Excel 2003. I am trying to count the number of zip codes in a
column. I have already copied and pasted the zip codes into a separate sheet in my workbook. I need to know how many 12345 zips, how many 12346 zips, etc. So I want something like this as a result: 12345 2 12346 1 12347 3 12354 22 What I don't want is something like this: 12345 2 12345 2 12346 1 12347 3 12347 3 12347 3 (this is assuming that the list on the left is my original list of zip codes) So, I need something to display the zips in one column (not necessarily the original data column) and then the count of each occurance of the zip code. I am trying to make a report to use with a bulk mailing. I keep thinking that it's a countif statement, but I'm not having any luck. When I try a pivot table (granted, I've only done a pivot table successfully on one other project and it was a sum, so I could easily be doing this incorrectly) I only get a count of all the zip codes in my column. However, if all I can get is a count like in my example (whether with a countif or with a pivot or with a nested statement), I can work with it. Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using COUNTIF and NOW() together | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |