Count number of occurrences only once

[Ber93]

Good afternoon

I have a column where values are repeated many times. I need to count the occurrences of each value in another column, so I was thinking to use COUNTIF, but if I extend COUNTIF over the entire column, the occurrences of each value will be counted each time the value appears. I need each value's occurrences to be counted only once, like shown in the example screenshot

[#2 · Accepted solution]

@Ber93 

=IF(COUNTIF($CL$1:CL2,CL2)>1,"",COUNTIF($CL$1:$CL$1000,CL2))

Maybe with this formula.

[#3]

Works perfectly! Thank you