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
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