I'd use a PivotTable.
I have a list of 2000 addresses. City, state, and Zip. I want to count how many of each exist in the sheet. Column A contains city. I want the results to return the number of occurances of each city. Can someone map out the syntax for me? THanks,
Mark
I'd use a PivotTable.
You could use the Countif function, and Excel will step you right through it. It would be something like =COUNTIF(A1:A2000,"City Name"). But you would have to do that separately for each city. Faster way would be to sort it by your city column, and then do subtotals. That would give you subtotals for each city.
Like this thread? Share it with others