I am trying to list the elements in a table, but I’m having a problem. I want to only list each Unique Unit Name once. I have a key row that has a double listing and I only want a single list from the double list. I want it to only look like this: [image] But instead I get this: [image] I under…

Try this filter - thisTable.Filter([Unique Unit Name]=thisRow.[Unique Unit Name]).First()=thisRow

Showing only the unique rows in a table without repeats

Paul_Hitchenson November 20, 2018, 12:52am 7

Done, link below

Topic		Replies	Views
Creating a button to identify & remove duplicate rows	5	3277	April 25, 2024
How do I filter the table to get only unique rows?	9	2655	February 27, 2023
Find Unique Matches in Another Table	2	1078	March 10, 2019
Allow only unique value in a column	6	3949	August 29, 2018
Lookup Table with Unique Names Only	12	4505	August 20, 2021