I'm trying to count how many times unique values show in a column tied to a particular criteria. I need to count how many items a particular location has, but only count the item once even if it repeats over a range of dates:
Example
Example
Location | Count of Values | Location | Values | |
Store 1 | ? | Store 1 | Value 1 | |
Store 2 | ? | Store 1 | Value 1 | |
Store 3 | ? | Store 1 | Value 2 | |
Store 1 | Value 2 | |||
Store 1 | Value 2 | |||
Store 2 | Value 1 | |||
Store 2 | Value 1 | |||
Store 2 | Value 2 | |||
Store 2 | Value 2 | |||
Store 2 | Value 2 | |||
Store 3 | Value 1 | |||
Store 3 | Value 1 | |||
Store 3 | Value 2 | |||
Store 3 | Value 2 | |||
Store 3 | Value 2 |