Forum Discussion
Dynamic Unique List - 2 Columns
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 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.
- Hi Riny, could you kindly direct me to the functionality in PQ be for something like this? I think I might explore it.
Tony2021 The link below would be a good place to start.
https://exceloffthegrid.com/power-query-introduction/
The idea is to connect to the data, and do the necessary transformations, groupings etc. How exactly depends on the structure of the data. In your case I can imagine you select the columns you want to check. Merge them and then remove duplicates. But I might change my mind if I see the data. And, as always, there are probably many other ways to achieve something similar.
- nice! that works great. thank you so much. Happy Holidays.