Hi,
i'm having trouble trying to count the unique values/entries on column B (name) that has the ff conditions the date should be from july 1-5 for week one, week two ..etc, and team (red, etc..) as seen below.
if i need the count of unique names for the first week on red team it should return = 3. i tried using sumproduct(((date>=jul1)*(date<=jul5)),--(team="red").. but im stuck on how to only count the unique values.
please help. what formula should i use?
thank you.
<tbody>
</tbody>
i'm having trouble trying to count the unique values/entries on column B (name) that has the ff conditions the date should be from july 1-5 for week one, week two ..etc, and team (red, etc..) as seen below.
if i need the count of unique names for the first week on red team it should return = 3. i tried using sumproduct(((date>=jul1)*(date<=jul5)),--(team="red").. but im stuck on how to only count the unique values.
please help. what formula should i use?
thank you.
1-Jul | 8-Jul | ||
5-Jul | 12-Jul | ||
Team | Week One | Week Two | |
Red | 3 | ||
Blue | |||
date | name | team | product |
1-Jul | mike | red | c |
1-Jul | dave | blue | a |
1-Jul | mike | red | a |
1-Jul | pat | red | a |
1-Jul | mike | red | b |
2-Jul | mike | red | a |
2-Jul | dave | blue | a |
2-Jul | dave | blue | a |
2-Jul | cris | blue | a |
2-Jul | cris | blue | b |
3-Jul | mike | red | b |
4-Jul | bert | red | c |
5-Jul | mike | red | c |
<tbody>
</tbody>