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