# Add function to remove duplicates to formular

**URL:** <https://connect.superhuman.com/t/add-function-to-remove-duplicates-to-formular/45778>\
**Category:** Ask the Community\
**Created:** [January 15, 2024, 12:42pm UTC](https://connect.superhuman.com/t/add-function-to-remove-duplicates-to-formular/45778 "2024-01-15T12:42:42Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Isebar\_DE](https://avatars.discourse-cdn.com/v4/letter/i/6bbea6/32.png) [@Isebar\_DE](https://connect.superhuman.com/u/Isebar_DE)\
**Post date:** [January 15, 2024, 12:42pm UTC](https://connect.superhuman.com/t/add-function-to-remove-duplicates-to-formular/45778/1 "2024-01-15T12:42:42Z")

</div>

Hi community,

i have this formula. Its combining all cells of a column. How do i need to modify it, so it does remove all duplicates as well?

Concatenate(FormulaMap(Connector.ContactTags, CurrentValue.ToText() + "; "), “”)

 ![image](https://global.discourse-cdn.com/coda1/original/3X/e/4/e466676e16b418371346ac5ee7331fe5a4c2445b.jpeg)

Thx alot.

---

<div class="post-metadata">

**Author:** ![Rickard\_Abraham](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/rickard_abraham/32/35007_2.png) [@Rickard\_Abraham](https://connect.superhuman.com/u/Rickard_Abraham)\
**Post date:** [January 15, 2024, 12:50pm UTC](https://connect.superhuman.com/t/add-function-to-remove-duplicates-to-formular/45778/2 "2024-01-15T12:50:30Z")

</div>

Hey there 🙂  
Probably just add `.Unique()` to `Connector.ContactTags`

---

<div class="post-metadata">

**Author:** ![Isebar\_DE](https://avatars.discourse-cdn.com/v4/letter/i/6bbea6/32.png) [@Isebar\_DE](https://connect.superhuman.com/u/Isebar_DE)\
**Post date:** [January 15, 2024, 3:25pm UTC](https://connect.superhuman.com/t/add-function-to-remove-duplicates-to-formular/45778/3 "2024-01-15T15:25:29Z")

</div>

Thx Rick. I still cant’ make it to work- i am very new with coda. Can you write the whole formula?

---

<div class="post-metadata">

**Author:** ![Rickard\_Abraham](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/rickard_abraham/32/35007_2.png) [@Rickard\_Abraham](https://connect.superhuman.com/u/Rickard_Abraham)\
**Post date:** [January 15, 2024, 4:17pm UTC](https://connect.superhuman.com/t/add-function-to-remove-duplicates-to-formular/45778/4 "2024-01-15T16:17:47Z")

</div>

Oh alright, welcome to Coda!

I was thinking like this 🙂

```auto
Concatenate(FormulaMap(Connector.ContactTags.Unique(), CurrentValue.ToText() + "; "), "")

```

You can also probably make the formula cleaner, like this

```auto
Connector.ContactTags.Unique().Join("; ")

```

---

<div class="post-metadata">

**Author:** ![Isebar\_DE](https://avatars.discourse-cdn.com/v4/letter/i/6bbea6/32.png) [@Isebar\_DE](https://connect.superhuman.com/u/Isebar_DE)\
**Post date:** [January 15, 2024, 4:36pm UTC](https://connect.superhuman.com/t/add-function-to-remove-duplicates-to-formular/45778/5 "2024-01-15T16:36:48Z")

</div>

@Rickard_Abraham It’s strange. Everything what ChatGPT gave me and both of your formulas don’t create a error, but the word count stays always the same…

---

<div class="post-metadata">

**Author:** ![Isebar\_DE](https://avatars.discourse-cdn.com/v4/letter/i/6bbea6/32.png) [@Isebar\_DE](https://connect.superhuman.com/u/Isebar_DE)\
**Post date:** [January 16, 2024, 2:57pm UTC](https://connect.superhuman.com/t/add-function-to-remove-duplicates-to-formular/45778/6 "2024-01-16T14:57:09Z")

</div>

Solution:

unique(split(Concatenate(FormulaMap(Connector.[Your Column], CurrentValue.ToText() + “; “), “”),”;”))

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [January 19, 2024, 2:57pm UTC](https://connect.superhuman.com/t/add-function-to-remove-duplicates-to-formular/45778/7 "2024-01-19T14:57:51Z")

</div>

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.