Help on duplicates - have already visited cpearson.com

[Guest]

I've spent the morning trying to figure this out - I have a series of values
in 1 column, and I simply need determine if they are also in column 2, and if
so, eliminate the row they're in. I looked at
www.cpearson.com/excel/duplicat.htm, and have tried the array formula
=IF(COUNTIF($A$1:$A$3030,B1)=0,B1,"") to see if the values exists, but I'm
not having much luck. Can anyone help? Thanks.

 

[Frank Kabel]

Hi
in C1 enter:
=IF(COUNTIF($B$1:$B$100,A1),"X","")
copy down for all rows and afterwards filter with this column.
delete the filtered rows

 

[JulieD]

Hi Katiekay

pasting the formula in column C (doesn't need to be array entered) &
dragging down works for me ... i get the "B1" value in C1 if it is not found
in A1 and nothing if it is.

i could then copy column C, edit / paste special values over column B and
now i have all the values in column A and only the unique ones in column B.

if this isn't what you want could you explain what you mean by "eliminate
the row they're in" - if A1 has 5, A2 has 10 and B2 has 5 do you really want
row 2 deleted?

Cheers
JulieD

 

[Guest]

Frank,
Thanks so much. That worked perfectly.

Hi
in C1 enter:
=IF(COUNTIF($B$1:$B$100,A1),"X","")
copy down for all rows and afterwards filter with this column.
delete the filtered rows

 

[Guest]

Hi Julie,
Thanks for the help. The numbers are code numbers. If they show up, then
that means the subject did not meet inclusion criteria, and need to be
eliminated. Frank's suggestion worked really well, but I may give your
suggestion a try next time.
K

 

[JulieD]

Hi Katie

glad its solved

Cheers
JulieD

Hi Julie,
Thanks for the help. The numbers are code numbers. If they show up, then
that means the subject did not meet inclusion criteria, and need to be
eliminated. Frank's suggestion worked really well, but I may give your
suggestion a try next time.
K