Hi,

I want to intersect to columns (if I may use that properly). I think I
can explain this by an example

Say I have 2 worksheets

Worksheet 1 --------- column A

jan
feb
mar
summer
winter
april
may

Worksheet 2 --------- column D

can contain several instances of some elements column A or might not
contain some of them,

I want to locate this "some of them" and remove them from Column A

eg. suppose worksheet 2 -------------- column D has

april
jan
feb
winter
summer
winter
feb
jan
april

then i want to remove

mar
may

from worksheet 1 -- column A

I can probably do this with countif

but the columns are both dynamic!!

Thankx in advance

karthik