Forum Discussion
Solved
Help needed - Counting unique entries
Can anyone help create formulas that get me the data I'm looking for in the orange cells on the attached?
In J3:
=IF(COUNTIF($C$2:$C$781, ">"&F3)=0, 0, COUNTA(UNIQUE(FILTER($B$2:$B$781, $C$2:$C$781>F3))))
Fill down to J4,
Thank you very much.
In J3:
=IF(COUNTIF($C$2:$C$781, ">"&F3)=0, 0, COUNTA(UNIQUE(FILTER($B$2:$B$781, $C$2:$C$781>F3))))
Fill down to J4,
