Forum Discussion

ajmal_pottekattil_yoousuf's avatar
May 24, 2024

Remove the duplicate

In this below example the we needed to only retain the "3A Cryogenic FZE" and 3C Metal Middle East FZE" 

 

Other remaining should be delete

 

Some More Examples

I want to remove the "A ONE SWITCHGEAR INDUSTRIES LLC,Manoj Pillai

 

 

  • ajmal_pottekattil_yoousuf 

    =IF(OR(A1="3A Cryogenic FZE",A1="3C Metal Middle East FZE",A1="A ONE SWITCHGEAR INDUSTRIES LLC"),A1,"")

     

    This formula is in cell B1 and filled down to cell B8. If you work with Office 365 or Excel for the web you can apply the FILTER function. An alternative with traditional Excel would be advanced filter.

Resources