Forum Discussion
How to get sets of unique data from a column which contains combined data (names)
We have a list with combined pairs of technicians names, as demonstrated in the screenshot below. How can I find how many unique sets of 3 (or 5 or 6 or 10 etc.) pairs are there? How can I get ...
Hi Mehdi ,
Thank you fo your effort.
Sorry that im not enough clear (my english.....)
In each cell there are 2 tecnicians ie A2 contains Mr Andreou Dimitrios and Mr Apostolou Vasileios.
Okay in bulding pairs sheet we can have two columns Tech01 and Tech 02. In total we have 1266 unique pairs.
We want to divide this summation in the groups (3 or 5 or 10 etc) of pairs.
The rule is that each group must contain always unique names.
Hi Manolis,
My english is also not so good. So what I propose you is to provide a exemple with original data and the final result you want to obtain not the whole of the data but just a sample.