cunningAce
Board Regular
- Joined
- Dec 21, 2017
- Messages
- 91
- Office Version
- 365
- Platform
- Windows
Hi,
In the example below I want to be able to enter the date and have the formula return the number of unique ID's related to it.
So the result would be 9 in this case.
Thanks in advance for your help
<tbody>
</tbody>
In the example below I want to be able to enter the date and have the formula return the number of unique ID's related to it.
So the result would be 9 in this case.
Thanks in advance for your help
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Date | ID | Date | Count | |
2 | 18/06/2018 | 1 | 18/06/2018 | ||
3 | 18/06/2018 | 1 | |||
4 | 18/06/2018 | 1 | |||
5 | 18/06/2018 | 2 | |||
6 | 18/06/2018 | 2 | |||
7 | 18/06/2018 | 2 | |||
8 | 18/06/2018 | 3 | |||
9 | 18/06/2018 | 4 | |||
10 | 18/06/2018 | 5 | |||
11 | 18/06/2018 | 6 | |||
12 | 18/06/2018 | 6 | |||
13 | 18/06/2018 | 7 | |||
14 | 18/06/2018 | 7 | |||
15 | 18/06/2018 | 7 | |||
16 | 18/06/2018 | 8 | |||
17 | 18/06/2018 | 8 | |||
18 | 18/06/2018 | 9 | |||
19 | 18/06/2018 | 9 | |||
20 | 18/06/2018 | 9 |
<tbody>
</tbody>
Last edited: