Checking duplicate codes

Hi,

Please I have a file containing list of staff and codes in a sheet named codes. In the confirmation sheet, I want excel to confirm codes that are available in the list and also check duplicates. The countif formular works fine for confirming available but is not checking duplicate. Please what I need is a formular the will also check duplicates.

Thanks.