Unique List

Ask for Help
2

Here is a technique that I learned from @Jeff_Hager. You will need a RowID column in your sheet.

  1. Create a self-relation linking the company name to itself. This should be a single relation (call this rel-self)
  2. Create a Lookup column to fetch the RowID from that relation (call this lk-unique-id)
  3. Finally, create an if-then-else column: If RowId is lk-unique-id, then true. Else blank. (call this ite-is-unique)

You can now use this last column to filter your Inline List: “where ite-is-unique is true”

5 Likes