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.
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 ^^
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
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