Erase Duplicates

[John]

I have data that tracks hits over the period of 11 months. Everytime a
person in an office is hit, it return the number 1. I want to show how many
people were hit over 11 months in each office and not the number of times the
office was hit

 

[Bernie Deitrick]

John,

Use a pivot table, set to count or sum.

HTH,
Bernie
MS Excel MVP