Oct 07 2020 02:10 AM - edited Oct 07 2020 03:32 AM
Hello
I want to use the new "Unique" function on multiple columns and get the list of unique values in a single column, is there a way to do that using the new dynamic arrays?
Thanks!
Edit: Added example file.
There are 2 lists, list A and list B. My goal is to create another list which consists of the unique values of list A and list B. In the example file I achieved this by simply using the Unique function for list A and list B seperatly in column E and then use the unique function again for the range in column E in column G.
The problem is that this method breaks if I increase the number of unique items in list A, as the cell for the dynamic array is already occupied.
So my question is there a way to do this with the new dynamic arrays that is not dependant on the number of entries and unique items?
Oct 07 2020 02:49 AM
If I can recommend you, add a file (without sensitive data) and describe your plan on it. This means that you can be helped more quickly and the best possible solution tailored to your needs can be offered. So everyone is helped.
Help to be helped.
* It's always good to add your operating system and Excel version.
As far as I know, here is some information that might help you.
https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e
Thank you for your understanding and patience
Nikolino
I know that I don't know (Socrates)
Oct 07 2020 02:54 AM
Oct 07 2020 03:33 AM
Thanks for the reply. I added a file and some more text in the opening post as per your advice.
Oct 07 2020 05:21 AM
Oct 09 2020 11:22 AM
That could be like
=SORT(UNIQUE(INDEX($A$2:$D$19,MOD(SEQUENCE(2*18)-1,18)+1,INT(SEQUENCE(2*18,,18)/18))))
concrete size you may calculate by COUNTA()
Oct 09 2020 12:04 PM
@Sergei Baklan That works! Thanks a lot.
Oct 09 2020 01:56 PM
@Swengineer , you are welcome
Jul 19 2022 04:58 AM