Forum Discussion
Solved
Dynamic Unique List - 2 Columns
Hello, I can create a dynamic unique list with 1 column of data but what I need now is a dynamic unique list of data in 2 columns. I have an example formula in the attached file but it only work...
Tony2021 Never tried that before but perhaps like in the attached file.
If this is not what you had in mind, I'd suggest you look into Power Query. Much more flexible and robust for these kind of tasks. At least in my humble opinion.
Tony2021 How about = UNIQUE(A2:B9) as shown in the picture below?