Tubbies001
New Member
- Joined
- May 29, 2018
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Dear Forum Members,
I would like to build a formula that would count Consultant IDs (only once, as they repeat) of consultants with Start Month "04" and the kit "S" (so in my below example the result is 1).
<tbody>
</tbody>
Thank you very much for any tips!
Margo
I would like to build a formula that would count Consultant IDs (only once, as they repeat) of consultants with Start Month "04" and the kit "S" (so in my below example the result is 1).
Consultant ID | Start month | Kit | |
<tbody> </tbody> | 03 | S | |
100732 | 04 | F | |
100732 | 04 | F | |
100732 | 04 | F | |
100735 | 02 | J | |
100735 | 02 | J | |
100737 | 04 | S | |
100737 | 04 | S |
<tbody>
</tbody>
Thank you very much for any tips!
Margo