I need a unique count of users within each week.
Sample Data:
<tbody>
</tbody>
Any ideas on this one?
Sample Data:
Date | Name | Week Number | Sum of Unique Count of users each week (Need Formula for this one) | Expected RESULT |
2/1/2017 | Donald | 5 | 3 | |
2/1/2017 | Goofy | 5 | 3 | |
2/1/2017 | Minnie | 5 | 3 | |
2/2/2017 | Donald | 5 | 3 | |
2/2/2017 | Minnie | 5 | 3 | |
2/15/2017 | Donald | 7 | 2 | |
2/16/2017 | Donald | 7 | 2 | |
2/16/2017 | Minnie | 7 | 2 |
<tbody>
</tbody>
Any ideas on this one?