E Edie Jul 22, 2003 #1 If I have one column with 900 rows of data, how can I make a search for duplicates? Thanks!
B Bob Phillips Jul 22, 2003 #2 Edie, You could put a formula in an adjacent column that shows them up, such as =IF(COUNTIF($A$1:$A$900,A1)>1,"Duplicate","")
Edie, You could put a formula in an adjacent column that shows them up, such as =IF(COUNTIF($A$1:$A$900,A1)>1,"Duplicate","")
2 2rrs Jul 23, 2003 #3 Edie, This formula will lable as duplicate all entries with more than 1 occurrence. It assumes that the 1st occurrence is not a duplicate. with your data starting in C3 =IF(ISNUMBER(MATCH(C3,$C$2:C2,0)),"Duplicate","") copy down HTH, 2rrs
Edie, This formula will lable as duplicate all entries with more than 1 occurrence. It assumes that the 1st occurrence is not a duplicate. with your data starting in C3 =IF(ISNUMBER(MATCH(C3,$C$2:C2,0)),"Duplicate","") copy down HTH, 2rrs
