how to count

excelNewbie22

Well-known Member
Joined
Aug 4, 2021
Messages
510
Office Version
  1. 365
Platform
  1. 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:
test
CDEFGH
2123567
3123568
41235610
51235611
61235613
71235615
81235619
91235620
101235623
111235624
121235625
131235627
141235629
151235631
161235632
171235633
182513232932
19278112036
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....
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
forgot the edit the title, can an admin please edit it?
"extract all unique combinations"
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top