excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi!
how to extract all the combinations (c2:h2, c3:h3 etc) which has at least 4 unique numbers against all others in the range?
and since there's a lot of combinations with same 4 numbers, just choose/extract the first one and ignore the rest
even if it is a long way... i don't mind
for example:
for this range, the unique combinations are:
1-2-3-5-x-x / 1-2-3-5-6-7 and ignore the rest 1-2-3-5-6-8 and 1-2-3-5-6-10 and etc
2-5-13-23-29-32
2-7-8-11-20-36
hoping someone will understand my intentions and hoping someone could help....
how to extract all the combinations (c2:h2, c3:h3 etc) which has at least 4 unique numbers against all others in the range?
and since there's a lot of combinations with same 4 numbers, just choose/extract the first one and ignore the rest
even if it is a long way... i don't mind
for example:
test | ||||||||
---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | |||
2 | 1 | 2 | 3 | 5 | 6 | 7 | ||
3 | 1 | 2 | 3 | 5 | 6 | 8 | ||
4 | 1 | 2 | 3 | 5 | 6 | 10 | ||
5 | 1 | 2 | 3 | 5 | 6 | 11 | ||
6 | 1 | 2 | 3 | 5 | 6 | 13 | ||
7 | 1 | 2 | 3 | 5 | 6 | 15 | ||
8 | 1 | 2 | 3 | 5 | 6 | 19 | ||
9 | 1 | 2 | 3 | 5 | 6 | 20 | ||
10 | 1 | 2 | 3 | 5 | 6 | 23 | ||
11 | 1 | 2 | 3 | 5 | 6 | 24 | ||
12 | 1 | 2 | 3 | 5 | 6 | 25 | ||
13 | 1 | 2 | 3 | 5 | 6 | 27 | ||
14 | 1 | 2 | 3 | 5 | 6 | 29 | ||
15 | 1 | 2 | 3 | 5 | 6 | 31 | ||
16 | 1 | 2 | 3 | 5 | 6 | 32 | ||
17 | 1 | 2 | 3 | 5 | 6 | 33 | ||
18 | 2 | 5 | 13 | 23 | 29 | 32 | ||
19 | 2 | 7 | 8 | 11 | 20 | 36 | ||
test |
for this range, the unique combinations are:
1-2-3-5-x-x / 1-2-3-5-6-7 and ignore the rest 1-2-3-5-6-8 and 1-2-3-5-6-10 and etc
2-5-13-23-29-32
2-7-8-11-20-36
hoping someone will understand my intentions and hoping someone could help....