K
karthik
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
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