# How to get all the unique values from a select list of select from table

**URL:** <https://connect.superhuman.com/t/how-to-get-all-the-unique-values-from-a-select-list-of-select-from-table/1130>\
**Category:** Ask the Community\
**Created:** [June 10, 2018, 5:40pm UTC](https://connect.superhuman.com/t/how-to-get-all-the-unique-values-from-a-select-list-of-select-from-table/1130 "2018-06-10T17:40:46Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![Daniel\_Stieber](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/daniel_stieber/32/17045_2.png) [@Daniel\_Stieber](https://connect.superhuman.com/u/Daniel_Stieber)\
**Post date:** [August 7, 2018, 5:17am UTC](https://connect.superhuman.com/t/how-to-get-all-the-unique-values-from-a-select-list-of-select-from-table/1130/6 "2018-08-07T05:17:50Z")

</div>

I love your solution @chris_homburger , since often you just need to think from another angle to get it working 🙂

There is a nasty way to work with lists/table lookups out of a cell.

In [LIP2](https://connect.superhuman.com/t/game-lip2-out-of-the-dark/1791/6), I needed something similiar to calculate, if you have the right items in your inventory to interact with an object or not. The only way I could find was to flatten these “formatted lists” using “totext()” in a formula map – just to split it up again to a real and clean list.

For your example instead of:  
`=[Fruit salads].Fruits.ListCombine().Unique()`  
you could make  
`=[Fruit salads].Fruits.ListCombine().FormulaMap(ToText(CurrentValue)).split(", ").Unique()`  
to get the results.  
Note that in the split formula you have to use ", " instead of “,” (so with a space), to get it right.

To get the leftovers, you can filter the fruits down (I named the first formula “inUse”, so it represents our in use list)  
`=Fruits.filter(in(fruit,inUse)=false).fruit`

 ![46](https://global.discourse-cdn.com/coda1/original/2X/b/b19b910bc43118b07d8ff1cbc70ffa7b9b604893.jpg)

Maybe this flatteing could also be a workaround for your importing case @Philipp_Alexander_Asbrand-Eickhoff?

---

_[View the full topic](https://connect.superhuman.com/t/how-to-get-all-the-unique-values-from-a-select-list-of-select-from-table/1130)._