Forum Discussion

Yugandhar__Y's avatar
Yugandhar__Y
Copper Contributor
May 10, 2020

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

 

excel

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 11, 2020

    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.

  • amit_bhola's avatar
    amit_bhola
    Iron Contributor
    May 10, 2020

    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.

Resources