Finding duplicate entries within a column
I am trying to find formula that would help me find the duplicate entries within a column. I am looking for the 1st entry to be tagged as "Unique" and any subsequent duplicated entries as"Duplicate".
Please e-mail Mazhar_Alam@dell.com if possible.
Assuming your original list if items is in column A starting in row 1
In B2 type: =IF(COUNTIF(A$1:A2,A2)>1,"Duplicate","Unique")
Copy this formula down as far as you need
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1