I have two sheets, one named, "DATA" and another named, "STATS".
I need to enter a formula in a cell in the "STATS" sheet that will count the number of unique dates in column G from the "DATA" sheet but ONLY IF column F contains the text, "JC".
<tbody>
</tbody>
So the formula should have the outcome of showing 3. as there are 3 unique dates that also have "JC" in column F.
Thanks in advance for you help. I have tried other formulas from other posts on this site and others but just can't seem to get to the correct outcome that I want.
I need to enter a formula in a cell in the "STATS" sheet that will count the number of unique dates in column G from the "DATA" sheet but ONLY IF column F contains the text, "JC".
F | G |
JC | 22/10/2017 |
JC | 22/10/2017 |
AF | 22/10/2017 |
BE | 17/10/2017 |
JC | 15/10/2015 |
JC | 14/10/2017 |
BE | 14/10/2017 |
BE | 12/10/2017 |
AF | 22/10/2017 |
<tbody>
</tbody>
So the formula should have the outcome of showing 3. as there are 3 unique dates that also have "JC" in column F.
Thanks in advance for you help. I have tried other formulas from other posts on this site and others but just can't seem to get to the correct outcome that I want.