# Unique List **URL:** \ **Category:** Ask for Help\ **Created:** [March 15, 2021, 7:03am UTC](https://community.glideapps.com/t/unique-list/24276 "2021-03-15T07:03:02Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 15, 2021, 7:03am UTC](https://community.glideapps.com/t/unique-list/24276/1 "2021-03-15T07:03:02Z")
Hi, do you have any ideas on how to make a list of unique ? For example, I have: **Company | Model | Status | Type | Amount** Abc Sdn Bhd | GS-1000 | Open | Machine | $100,000 Abc Sdn Bhd | GS-1002 | Won | Rental | $5,000 Def Sdn Bhd | GS-2000 | Lost | Machine | $200,000 Ghi Sdn Bhd | GS-2000 | Open | Machine | $200,000 Ghi Sdn Bhd | GS-1000 | Open | Rental | $5,000 Ghi Sdn Bhd | GS-1000 | Won | Rental | $5,000 I want it to be unique for company name: **Company** Abc Sdn Bhd Def Sdn Bhd Ghi Sdn Bhd And when I click one of the company name it will be showing: (I click Ghi Sdn Bhd for example) 3 Enquries , 2 Open, 1 Won, Total Won Amount : $5,000 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 15, 2021, 7:17am UTC](https://community.glideapps.com/t/unique-list/24276/2 "2021-03-15T07:17:40Z")
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” ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 15, 2021, 7:57am UTC](https://community.glideapps.com/t/unique-list/24276/3 "2021-03-15T07:57:22Z")
Ghi Sdn Bhd | GS-2000 | Open | Machine | $200,000 | TRUE Ghi Sdn Bhd | GS-1000 | Open | Rental | $5,000 | Ghi Sdn Bhd | GS-1000 | Won | Rental | $5,000 | It will be like this. And how do make a sum of the status ? Open 2 , Won 1 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 15, 2021, 8:05am UTC](https://community.glideapps.com/t/unique-list/24276/4 "2021-03-15T08:05:37Z")
Sum of the status doesn’t really make sense. Do you mean sum of the amounts per company? To do that you need a self-relation (multi-relation), and then use a rollup column through that relation. Just getting back to your original question… > [@biha](#): > > And when I click one of the company name it will be showing: > (I click Ghi Sdn Bhd for example) > 3 Enquries , 2 Open, 1 Won, Total Won Amount : $5,000 There are a few different ways to get something like that. Give me a little while and I’ll make an example for you. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 15, 2021, 8:39am UTC](https://community.glideapps.com/t/unique-list/24276/5 "2021-03-15T08:39:20Z")
@biha - I made an example that you can study and copy. Note that I am assuming that you have a table with a list of companies, and a separate table with a list of orders. Look at the `companies` and `orders` Glide Tables in this app, and the Companies tab. > **[Glide Community Forum](https://glide-community.glideapp.io/)** > > This app uses anonymised email addresses.