# Remove duplicates

**URL:** <https://community.glideapps.com/t/remove-duplicates/68273>\
**Category:** Ask for Help\
**Created:** [November 30, 2023, 6:52pm UTC](https://community.glideapps.com/t/remove-duplicates/68273 "2023-11-30T18:52:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nsingleton1](https://avatars.discourse-cdn.com/v4/letter/n/91b2a8/32.png) [@nsingleton1](https://community.glideapps.com/u/nsingleton1)\
**Post date:** [November 30, 2023, 6:52pm UTC](https://community.glideapps.com/t/remove-duplicates/68273/1 "2023-11-30T18:52:56Z")

</div>

I have a sheet with listings. There are a lot of duplicates which is intentional because the same item may have been listed many times. However, when I show them in a collection, I don’t want to show all the duplicates. When someone selects and item, it takes them to graph and shows the item’s price over time. That works fine. However, I don’t know how to just show the distinct items in the collection component.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [November 30, 2023, 7:03pm UTC](https://community.glideapps.com/t/remove-duplicates/68273/2 "2023-11-30T19:03:05Z")

</div>

Try creating a single relation from the main column of the items (Row ID or Name) to the same column. It’s important that you uncheck ‘Multiple’. Then display that relation as the source of the collection.

EDIT: This answer is incorrect. See Thinh’s correct approach below.

> [@Remove duplicates](https://community.glideapps.com/t/remove-duplicates/68273/3):
>
> Creating a single relation from the item’s rowID to itself. Create a lookup to retrieve the rowID from the relation. That will be the first ID among all duplicates. Filter your collection by rowID equals “first ID”.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 30, 2023, 11:25pm UTC](https://community.glideapps.com/t/remove-duplicates/68273/3 "2023-11-30T23:25:04Z")

</div>

- Creating a single relation from the item’s rowID to itself.
- Create a lookup to retrieve the rowID from the relation. That will be the first ID among all duplicates.
- Filter your collection by rowID equals “first ID”.

---

<div class="post-metadata">

**Author:** ![nsingleton1](https://avatars.discourse-cdn.com/v4/letter/n/91b2a8/32.png) [@nsingleton1](https://community.glideapps.com/u/nsingleton1)\
**Post date:** [December 7, 2023, 10:07pm UTC](https://community.glideapps.com/t/remove-duplicates/68273/4 "2023-12-07T22:07:48Z")

</div>

This worked perfectly. Thank you!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 14, 2023, 10:07pm UTC](https://community.glideapps.com/t/remove-duplicates/68273/5 "2023-12-14T22:07:50Z")

</div>

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