Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
use countif()
and to make it more interesting mere it with conditional formating.
You can use COUNTIF formula in next column and it will show you the duplicates as "2" and "1" as unique entry.