All possibility combinations 7 numbers from 18 numbers

[Maxwell76]

Hi all,
I need help find all possibility combinations of 7 numbers from 18 knowing numbers?

Thanks,

[AliGW]

Which seven numbers???

[Maxwell76]

Hi,
The all combinations of 7 numbers from knowing 18 numbers, for example:
36,38,40,42,44,46,48
36,38,40,42,44,46,50
36,38,40,42,44,46,52 .....

Thanks,

[JohnTopley]

See attached: Sheet2

[Maxwell76]

Thanks,
Do you have formula for it, or you did it with micro?

BR

[davsth]

the below will work on newer versions of excel. but presents results slightly differently as as has a column for each number


https://www.get-digital-help.com/how...in-function/#5

[Maxwell76]

Wow, it's great, with explanation.
Thanks a lot.

[JohnTopley]

Macro which will do Permuations or Combinations: parameters in Sheet1

[HansDouwe]

Just for the fun:

If you update to Excel 365 a solution with this formula is also possible:

Please put the 18 numbers in A1:R1 and try:

Please Login or Register  to view this content.

Response time to find all the 31,824 combinations is on my laptop about 3 seconds.

[JEC.]

Combinations in VBA (recursive) based on John's file. Output is in separated cells.

Please Login or Register  to view this content.