Counting by Zipcode and other criteria
 

tHi,
How can I count the number of participants by their zipcode and another
criteria (such as office1, office2, office 3, etc.)?
There would probably be 5 subheading under each zipcode.

Thanks
Bruce

Counting by Zipcode and other criteria
 

Best bet is probably a Pivot Table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


In article ,
Perkgolf wrote:

tHi,
How can I count the number of participants by their zipcode and another
criteria (such as office1, office2, office 3, etc.)?
There would probably be 5 subheading under each zipcode.

Thanks
Bruce

Counting by Zipcode and other criteria
 

Thanks for the info. I'll try that.

Bruce

"JE McGimpsey" wrote:

Best bet is probably a Pivot Table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


In article ,
Perkgolf wrote:

tHi,
How can I count the number of participants by their zipcode and another
criteria (such as office1, office2, office 3, etc.)?
There would probably be 5 subheading under each zipcode.

Thanks
Bruce

Counting by Zipcode and other criteria
 

Hi,
When I get the table there are two many zipcodes to display on one chart.
How do I get them on multiple pages?

Bruce

"JE McGimpsey" wrote:

Best bet is probably a Pivot Table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


In article ,
Perkgolf wrote:

tHi,
How can I count the number of participants by their zipcode and another
criteria (such as office1, office2, office 3, etc.)?
There would probably be 5 subheading under each zipcode.

Thanks
Bruce