Forum Discussion
Removing Same values from 2 coloumns
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
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.