Removing Same values from 2 coloumns

[Yugandhar__Y]

I want to remove the same values in Column B & C. Any value which is in Col B, if it repeats in Col C, I want to remove both the cell values. Please support

[#2]

@Yugandhar__Y , here is a solution approach which uses just a series of excel formulas to achieve it.

See attached file.

Instead of just using it as is, i would suggest to go through the formulas and develop an understanding of how they worked. It would help you tweak them as per your need as necessary.

[#3]

@Yugandhar__Y  Or perhaps you mean this (see picture below).

Note: The FILTER function is currently available to Microsoft 365 subscribers in the Monthly channel. It will be available to Microsoft 365 subscribers in the Semi-Annual channel starting in July 2020.