Is there a quicker way to do this in Excel? (Counting records)
I have some data that is a list of records by city. The data is in an excel spreadsheet and every record is listed singularly with city names in column A and record type in column B. I have a few hundred different cities to go through and each city has anywhere from 1-500 records. Is there any way I can get excel to count up how many records there are for each city? Can I get it to quickly count how many record types there are for each city as well?