subtract text from one column if it maches with text of another column

I have 3 columns in excel.
column 1 contains set of text values.
column 2 contains sub set of values in column1.
i want column 3 to be filled with remaining values.

is it possible in excel, if yes please help.

My requirement is every row may contain some random strings.

The need is column 1 contains set of strings , column 2 contains subset of strings in column 1. The strings which are in 2nd column, if it matches with strings of column 1 needs to be subtracted and 3rd column to be filled by remaining string.

if it is possible in excel by using some loop/formula/vba, kindly reply.

Thanks

Hi bik

You could use a custom function to do this, for example..

Please Login or Register  to view this content.

see attached zip fie (containing example .xlsm file with this function and some examples)

zeddy

Thank you very much.

Thank you. Earlier i thought this will not be possible in excel, but your response made me believe that what ever question will be asked on Excel Forum will be solved in no time. Thanks a lot.

Yes, but which answer did you use as the "solution"

Your answer