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

checking duplicates

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

410 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *