Public | 1 | 2017 |
Public | 2 | 2018 |
Private | 3 | 2017 |
Private | 3 | 2018 |
Private | 4 | 2018 |
<tbody>
</tbody>
So I'm trying to count the number of unique combinations of the first two columns, then according to the date.
I currently have:
{=SUM(--(FREQUENCY(IF($A:$A="Public",MATCH($B:$B,$B:$B,0)),ROW($B:$B)-ROW($B$1)+1)>0))}
Which will count the number of unique combinations, however I don't know how to incorporate the date parameter into this.
Possibly using SUMPRODUCT?
Something along the lines of:
{=SUMPRODUCT(--(FREQUENCY(IF($A:$A=$E11,MATCH($B:$B,$B:$B,0)),ROW($B:$B)-ROW($B$2)+1)>0)*(C:C=2018))}
It just comes out as #VALUE
Thanks in advance