Hopefully I can explain this correctly:
=SUM(IF(FREQUENCY(MATCH($F$2:$F286, $F$2:$F286,0),MATCH($F$2:$F286, $F$2:$F286,0))>0,1))
That tells me if there is duplicates and counts just the unique ones. Works really well(always open to an easier formula)
Here's the issue the $F$2 is...