Removing Same values from 2 coloumns

Occasional Contributor

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 Replies

@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.


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

Screenshot 2020-05-11 at 06.50.00.png

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.