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
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 10, 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.