# Filter to display DISTINCT (or Unique) rows based on specified columns

**URL:** <https://community.glideapps.com/t/filter-to-display-distinct-or-unique-rows-based-on-specified-columns/70080>\
**Category:** Feature Requests\
**Created:** [January 26, 2024, 5:09pm UTC](https://community.glideapps.com/t/filter-to-display-distinct-or-unique-rows-based-on-specified-columns/70080 "2024-01-26T17:09:54Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 26, 2024, 10:51pm UTC](https://community.glideapps.com/t/filter-to-display-distinct-or-unique-rows-based-on-specified-columns/70080/3 "2024-01-26T22:51:42Z")

</div>

I typically use or recommend the following method:

- Make sure there is a Row ID column.
- Create a single Relation or Query to link similar rows to themselves based on similar values.
- Create a Lookup or Single Value column to retrieve the first matching Row ID from the Relation/Query.
- Finally create an IF column comparing the row’s Row ID to the Lookup/Single Value column and return true if there is a match. Only the first occurrence will be a match.

---

_[View the full topic](https://community.glideapps.com/t/filter-to-display-distinct-or-unique-rows-based-on-specified-columns/70080)._