Read Help for Pivot Table
Bernard V Liengme
remove caps from email
"Cindy" wrote in message
Column A is Town, Column B is names, Column C is how many in each
How can Excel add & tell me how many Smiths in each town and, if possible,
how many Smith families with 2 people in each town. Then I want to chart
info. How many of each family name by town.