Stupid Excel Question

Kevy Baby · 03-24-2007, 02:05 PM

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?

03-24-2007, 02:05 PM	#1
Kevy Baby Chowder Head Join Date: Jan 2005 Location: Yes Posts: 18,500	Stupid Excel Question 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? __________________ The thing about quotes on the internet is that you cannot verify their validity. - Abraham Lincoln
	Submit to Quotes