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 ...
1. Highlight column, go to Data tab, 'Text to Columns', choose Delimited then click Space 2. Then highlight all columns, go to Data tab and 'Remove Duplicates'
Hi Tanya ,
Many thanks for the swift response!
Please note that each cell already contain a unique pair of technicians.
We are looking for a way to find how may sets of 3 pairs (or 5 or 6 or 10..) there are in the column and how we can get these set/ groups of 3 (or 5 or 6....10 etc) unique pairs in separate columns.
i.e if someone name -first left word in the cell- is in the group cannot be into next group .
Any idea will be appreciated.
Again thank you!