Count number of occurrences only once

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