Here is one I cannot figure out.
I work with mailing lists frequently and often review them in Excel (I do not do any processing of the lists - I leave that to the programmers in their specialized mail programs - I just use the lists for reference). I have one mailing I do every month that I need to extract certain data out of. I know how to do it "manually", but there has to be a faster way.
Basically, I need to find out the count by counties in each of 16 regions within the list. How I do it now is:
- Select "Auto Filter"
- In the drop down selector (proper name unknown), select the first region, say for example, "ABCD"
- Go to the County column and select the first available county. Write down the name of the county and the quantity.
- Select the name of the second county, write down the name and quantity.
- Continue this until all counties in that region are accounted for
- Choose "Select All" under County, then select the next region and do steps 3-5 for that region. This is repeated until all sixteen regions and all records are counted.
I end up with a basic report that looks like this:
ABCD REGION
Alpha County: 23 records
Bravo County: 47 records
Charley County: 16 records
Delta County: 102 records
EFG REGION
Echo County: 77 records
Foxtrot County: 36 records
Obviously, this is tedious. I know there must be a simpler way to do this (especially since I actually have TWO lists each month I need to review this way!).
Any bright minds out there?