Clay Icon
Join the Community
02 Support

Hello here.

Avatar of rumjan y.rumjan y.
·
·

Hello here. I need a formula in my company name column where i need to remove all duplication of company name and leave only one. As the context is that i have many rows in my clay table where one company is recruiting many position in there company.

3 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Just replied to your other thread but in case you see this first: You can actually use our "dedupe" feature. If you click on the column header with duplicate values, it should be visible in the menu. Let me know if you run into any issues!

    3f8dcda5-8fcb-41c0-9fe9-987fca8d69d4.png(25 kB)