Forum Discussion
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 ...
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