combinations

[MBSIMON]

good day

> CAN YOU PLEASE HELP ME WITH THE FOLLOWING
>
> CAN NOT FIND ANY ANSWER IN BLOGS OR OTHER
>
>
>
>
>
> how can i select all possible combinations
>
> from list of SEVERAL columns like column a column b column c column d column e column f AN G and more
>
> in each column list of different numbers -in each column could be different quantity of numbers
>
> i would like to define ALL variable selection OF NON REPEATABLE COMBINATIONS from columns example
>
> that from column a select 1 number from B 2 numbers from c 1 number
>
> from d 2 numbers from g 3 numbers or other
>
>
>
>
>
> column a column b column c column d column e column f column g column h column i
>
> 400 406 410 900 901 1000 10000 300 600
>
> 402 915 1001 1012 2500 20000 301 601
>
> 404 10012 1003 2501 40000 302 603
>
> 409 1010 2502 50000 303 604
>
> 405 2555 100000 605
>
> 409
>
> RESULTS SUCH AS
>
> 400 406 410 900 901 1000 10000 300 600
>
> 402 406 410 900 901 1000 10000 300 600
>
> 404 406 410 900 901 1000 10000 300 600
>
> AND SO ON ALL COMBINATIONS
>
> now combination from 1 column 2 numbers and missing one number from another column
>
> 400 402 410 900 901 1000 10000 300 600
>
> 402 406 410 900 1001 1000 10000 300 600
>
> 404 406 915 900 901 1000 10000 300 600
>
> ALSO NEVER TO REPEAT SAME COMBINATION NOT TO BE REPEATED
>
> AS I DO NOT KNOW VB OR VBA
>
> CAN THIS BE ARRANGED ONLY WITH EXCEL FUNCTION
>
> THANKS AND BEST REGARDS
>
> thanks
pls send your answer
to
mbs...@netvision.net.il
>
> "
>