أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
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.
