Combine 2 Columns from 2 different sheets with 1 condition

[Sekars]

Hello Friends

I need to combine 2 columns from Sheet1 and Sheet2, in both sheets Column C should be combined.

But if any texts repeated then it should be plotted as is i.e., not removing duplicates.

But if any numbers repeated then it should be plotted once by removing the duplicate entires.

Now I had hardcored the expected results in the Sheet3, Column C light yellow cells.

thanks in advance

[azumi]

Hope this helps

[avk]

Are you required like this.
Other wise enter required data manually as per requirement.

[Sekars]

Hello Azumi

Thanks for your formula file, it is working file.


Hello avk

I have already hardcored the required result in Sheet 3 light yellow cells.