I am trying to use the new dynamic array formulas to return a list of unique values from multiple columns. I've seen how to do this with the "ctrl+shift+enter" arrays, but I was hoping to achieve it with a more efficient formula. I access to the new formulas, so it is a just a question of how to use the formula, not access it. Simply using the =UNIQUE(A1:B3) returns each unique row, not each unique value.
apple | banana | pear
cherry | apple | banana
mango | cherry | grape
to:
apple
banana
grape
mango
pear
cherry
Thank you,
Adam
Bookmarks