I need a unique count of users within each week.
Sample Data:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Week Number[/TD]
[TD]Sum of Unique Count of users each week (Need Formula for this one)[/TD]
[TD]Expected RESULT[/TD]
[/TR]
[TR]
[TD]2/1/2017[/TD]
[TD]Donald[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/1/2017[/TD]
[TD]Goofy[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/1/2017[/TD]
[TD]Minnie[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/2/2017[/TD]
[TD]Donald[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/2/2017[/TD]
[TD]Minnie[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/15/2017[/TD]
[TD]Donald[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2/16/2017[/TD]
[TD]Donald[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2/16/2017[/TD]
[TD]Minnie[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
Any ideas on this one?
Sample Data:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Week Number[/TD]
[TD]Sum of Unique Count of users each week (Need Formula for this one)[/TD]
[TD]Expected RESULT[/TD]
[/TR]
[TR]
[TD]2/1/2017[/TD]
[TD]Donald[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/1/2017[/TD]
[TD]Goofy[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/1/2017[/TD]
[TD]Minnie[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/2/2017[/TD]
[TD]Donald[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/2/2017[/TD]
[TD]Minnie[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/15/2017[/TD]
[TD]Donald[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2/16/2017[/TD]
[TD]Donald[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2/16/2017[/TD]
[TD]Minnie[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
Any ideas on this one?