Remove the duplicate

Iron Contributor

ajmalpottekattilyoousuf_0-1716577422571.png

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

ajmalpottekattilyoousuf_0-1716578019687.png

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

 

ajmalpottekattilyoousuf_1-1716578149612.png

 

3 Replies

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

remove the duplicate.png

@ajmal pottekattil yoousuf  I understood your question. You can get text before ", " Using textbefore formula and then use unique on that to remove duplicate value. 

 

Same you can find in below YouTube video. 

https://youtu.be/FdnokPGjN_M?si=1M2Dx_SF39FIFdqr

 

If you further queries you please ask here or comment in the YouTube video. Hope this gives you a clarity. 

 

@ajmal pottekattil yoousuf 

This is similar to @TV1809 but uses arrays rather than helper cells.  Calling your column of data 'list',

= UNIQUE(TEXTBEFORE(list, ",",,,1))

returns the 2 distinct items

image.png