To check for a duplicate entry in a column in excel

Take the Column in column A in which the duplicate value needs to be checked.
Use the Below formula in a new column say column B next to the A and insert the formula against it.

The status FALSE means that it is not an duplicate entry

The status TRUE means it is an duplicate entry