how to find duplicate values from excel sheet formula code example

Example: check duplicates in excel

CLICK ON REMOVE DUPLICATES ON TOP .
CLICK ON HOME -> THEN SELECT CELLS -> DUCPLICATE REMOVE
THEN CLICK OK