Help on duplicates - have already visited cpearson.com

K

katiekay

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.
 
F

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
 
J

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
 
K

katiekay

Frank,
Thanks so much. That worked perfectly.

Frank Kabel said:
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
Click to expand...
 
K

katiekay

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
 
J

JulieD

Hi Katie

glad its solved

Cheers
JulieD

katiekay said:
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
Click to expand...
 
Top