Erase Duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
John,

Use a pivot table, set to count or sum.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct but only first time corresponding value is seen e.g. un 1
Calculating weighted average of Percent Change 0
How to migrate Gmail to Office 365? 2
Eliminating Duplicate values on a large workbook 1
Count function 2
Removing duplicate records based off of date 3
Complicated Countif application 4
11 becomes 12 after hit return 3

Back
Top