| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting for unique values using 2 cells
I have a list of places our reps visit along with who they visited and
various other things. I then bring this data into a pivot table. I want to see a total of how many times they visited each Town, but I only want the town counted once of any date, so if they visit London on the 02/07/07 and went to 4 placed there will be 4 lines in the data but the pivot table only counts 1. But if they went to london on the 02/07/07 and then again on the 05/07/07 then the pivot table will count 2. Anybody got any ideas how this can be none? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Unique Values | Excel Discussion (Misc queries) | |||
| counting the # of unique values | Excel Worksheet Functions | |||
| Counting unique values | Excel Discussion (Misc queries) | |||
| Counting Unique Values | Excel Worksheet Functions | |||
| Counting Unique Values | Excel Worksheet Functions | |||
Threaded Mode
