# A list with only one result for every entry of the original list **URL:** \ **Category:** Ask for Help\ **Created:** [November 4, 2020, 10:57am UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930 "2020-11-04T10:57:01Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 4, 2020, 10:57am UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/1 "2020-11-04T10:57:01Z")
Hello everyone, I’d like to have a list (categories for example) that generates from a bigger list with entries that repeat but has to list only one entry for each kind. Sorry if I’m not explaining in a proper way. - ORIGIN LIST: -----------\> WANTED LIST: - ``` A A ``` - ``` A B ``` - ``` B C ``` - ``` A D ``` - ``` C ``` - ``` D ``` - ``` D ``` How should I accomplish this? Thanks anyone who will answer. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 4, 2020, 2:30pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/2 "2020-11-04T14:30:08Z")
I think the only way as of now is to use a unique function inside your Sheets. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 4, 2020, 4:13pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/3 "2020-11-04T16:13:45Z")
a function in google sheets? I’m not a great expert of sheets, thx for the suggestion though ---
**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:** [November 4, 2020, 4:27pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/4 "2020-11-04T16:27:49Z")
It’s not that difficult… ![Screen Shot 2020-11-05 at 12.25.24 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/aeff6604c0951e3ebd41aa072255924cf8841c02.png) The formula in cell G2 would be `=UNIQUE(F2:F)` ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 4, 2020, 7:19pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/5 "2020-11-04T19:19:12Z")
> [@Darren\_Murphy](#): > > `=UNIQUE(F2:F)` Thank you it works. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 4, 2020, 8:16pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/6 "2020-11-04T20:16:38Z")
Can I make a unique column from a column that is in another tab? Edit: I learned the command query that solved it, I was actually looking for this function for some time, a world of sheets is opening in front of me ^^ ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 4, 2020, 10:13pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/7 "2020-11-04T22:13:02Z")
I wrote 2 posts about Query here if you need it. > [@Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1)](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-1/10432): > > This topic was inspired by our last community meetup, in which we talked about some formulas in Google Sheets and some people want to know more about QUERY, which was branded [“The most powerful function in Google Sheets”](https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/) by famous GSheets teacher Ben Collins. So, what is QUERY, and why is it so powerful. Here’s a writeup on it, which hopefully would help many of you here in this community. Trust me, it would change so much how many of you “clean” your data in the future from raw data, in a very… > [@Tutorial - QUERY: “The most powerful function” in Google Sheets (part 2)](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-2/10849): > > If you have not read part 1, below is the direct link so you can have a read at what QUERY is, and how it can help your case, whether it be building Glide apps or make your normal day work easier. > > > **6/Dynamically sort your data using ORDER BY** > > > > An ORDER BY claused can be used to dynamically sort your data after being queried, and you can change the column that is used to sort with just a letter. By default, the ORDER BY sorts ascendingly, and it can grab the data type in the column automatically.… ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 5, 2020, 2:37pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/8 "2020-11-05T14:37:38Z")
Do you know if a query made in the wrong way can break the updating between glide and sheets? Cause it’s not been working since I made the changes with query and unique ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 5, 2020, 5:10pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/9 "2020-11-05T17:10:02Z")
Not sure what your formula is, but I think what you need can be solved simply by a unique function. Usually I do it in another sheet. If you do have some screenshots then it would be better for us to debug. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 5, 2020, 5:56pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/10 "2020-11-05T17:56:10Z")
![unique](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3bff53b86a6d490e9ae108e49409c3ab5503d52e.png) from this example of the sheets’ guide I understood how unique works and I should have solved, but I had to move the columns close to each other and in a specific order, which I preferred not to, but it will do for now ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 5, 2020, 6:14pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/11 "2020-11-05T18:14:40Z")
This should be all you need in a new sheet tab. `=UNIQUE({'SheetName'!A2:A,B2:B,F2:F})` Choose the columns and sheet name as needed. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 5, 2020, 6:30pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/12 "2020-11-05T18:30:42Z")
Oh, I didn’t use the array { } brackets that’s why it didn’t work. Thanks. EDIT: @Jeff_Hager, the function you wrote makes the unique of the data I give it, what I need is what is show in the screen shot I posted, I need the connected cells of the unique values, the above mentioned screenshot worked perfectly. Btw, I’m also working on the different questions you asked me in the other post, for now the only one I can tell you is that the entry I was trying to edit was on the bottom of the sheet