| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Erase Duplicates
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Erase Duplicates
John,
Use a pivot table, set to count or sum. HTH, Bernie MS Excel MVP "John" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Marking Duplicates | Excel Worksheet Functions | |||
| Duplicates | Excel Discussion (Misc queries) | |||
| Find and mark duplicates | Excel Discussion (Misc queries) | |||
| Finding Duplicates | Excel Worksheet Functions | |||
| Finding Duplicates and somehow flagging them in another column | Excel Discussion (Misc queries) | |||
Linear Mode
