# Table filter to only display most recent duplicate value

**URL:** <https://connect.superhuman.com/t/table-filter-to-only-display-most-recent-duplicate-value/20182>\
**Category:** Ask the Community\
**Created:** [December 16, 2020, 6:03pm UTC](https://connect.superhuman.com/t/table-filter-to-only-display-most-recent-duplicate-value/20182 "2020-12-16T18:03:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Scott\_Hill](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_hill/32/18106_2.png) [@Scott\_Hill](https://connect.superhuman.com/u/Scott_Hill)\
**Post date:** [December 16, 2020, 6:03pm UTC](https://connect.superhuman.com/t/table-filter-to-only-display-most-recent-duplicate-value/20182/1 "2020-12-16T18:03:59Z")

</div>

Our Goal: To create a filtered table view which only displays unique “product” values. When multiple “product” values exist, only display the record which contains the most recent date/time in column “created on” row.

In the example below, the filtered table view will only display the bottom three records since the first instance of apple in record one will be filtered out due to the date/time in record 4 being most recent.

| Product | Quantity | Created on |
| --- | --- | --- |
| Apple | 10 | 12/16/2020 11:50:28 AM |
| Orange | 20 | 12/16/2020 11:50:42 AM |
| Grapes | 15 | 12/16/2020 11:50:58 AM |
| Apple | 5 | 12/16/2020 11:51:08 AM |

Thanks in advance and I appreciate this community!

---

<div class="post-metadata">

**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\
**Post date:** [December 17, 2020, 6:36pm UTC](https://connect.superhuman.com/t/table-filter-to-only-display-most-recent-duplicate-value/20182/2 "2020-12-17T18:36:20Z")

</div>

Hi @Scott_Hill,

you might add an additional column - such as `Latest` - that shows if that row is the latest for that product with the following formula:

```auto
thisTable.Filter(Product=thisRow.Product).[Created On].Max() = thisRow.[Created On]

```

Then, you filter the table by `Latest` (=true) column.

Please, do let me know if it’s clear and/or you need additional explanations.  
Cheers

---

<div class="post-metadata">

**Author:** ![Scott\_Hill](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_hill/32/18106_2.png) [@Scott\_Hill](https://connect.superhuman.com/u/Scott_Hill)\
**Post date:** [December 18, 2020, 11:48am UTC](https://connect.superhuman.com/t/table-filter-to-only-display-most-recent-duplicate-value/20182/3 "2020-12-18T11:48:42Z")

</div>

@Federico_Stefanato

That is exactly what I’m looking for! Thank you for your help!

I appreciate you and everyone that took the time to review this topic!
