Counting by Zipcode and other criteria

[Perkgolf]

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

 

[JE McGimpsey]

Best bet is probably a Pivot Table:

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

 

[Perkgolf]

Thanks for the info. I'll try that.

Bruce

Best bet is probably a Pivot Table:

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

 

[Perkgolf]

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