Checking duplicates in excel column

If you want to find the duplicate rows of a column in the excel,

then you can use this formula,
=IF(MAX(COUNTIF($A$3:$A$12,$A$3:$A$12))>1,”Duplicate”,”Unique”)

Thanks for reading this post…!
Add your comments in the comment area below….!!