Hi Guys,
I have read multiple threads,Searched videos for this issue, and I haven't seem nothing to apply the solution to my spreadsheet.
this is what i got :
1-.range of 5 Numbers Combination,
2-.each number is using single Cell,
3-.Many of the combination are Duplicated
Already applied The Find Uniques/Duplicates with conditional Format.
Please I need to know (Either) a Function that Count Unique/Duplicated Combinations
OR
I need to know a Function that Extract Unique Combinations
Col--> R S T U V
R:8--> 11 13 22 31 33 <--Duplicated
R:9--> 01 08 10 15 28
R:10-> 02 04 06 17 31
R:11-> 01 08 10 28 30
R:12-> 11 16 22 28 34
R:13-> 02 04 06 26 31 <--Duplicated
R:14-> 02 04 06 26 31 <--Duplicated
R:15-> 01 10 15 27 32
R:16-> 04 12 13 22 29
R:17-> 06 07 19 25 26
R:18-> 05 07 12 13 22
R:19-> 06 19 25 26 34 <--Duplicated
R:20-> 06 19 25 26 34 <--Duplicated
R:21-> 11 13 22 31 33 <--Duplicated
Thank you !
Bookmarks