Quick excel help needed!

Associate
Joined
6 Jul 2003
Posts
2,075
Quick bit of help needed please fellas - I've got 2 excel columns, one is a subset of another:

Column 1
a
b
c
d

Column 2
a
b
c
d
e
f
g
h
i

I need to remove the data in column 1, from column 2, so column 2 looks like this:

Column 2
e
f
g
h
i

Theres about 600 rows in column 1 and 3000 in column 2, so doing it by hand isn't an option! Thanks for your time :)
 
split the columns up

perform a lookup to see if the cell in column 2 is in column 1,

order by results should be a decent start
 
Back
Top Bottom