Distribute all possible numbers to all persons

[YasserKhalil]

Hello everyone
I have some names and some numbers ..
There is a table : for each name there are available numbers for him ..
I need to take just one number and the number that is taken will be excluded ..
Here's an attachment to illustrate the problem
Thanks advanced for any help

 

[NARAYANK991]

Hi ,

One way to do it.

Narayan

 

[YasserKhalil]

Thanks a lot Mr. Narayan for the solution
Columns P:M are generated manullay??!
The results are not one way .. there are other possiblities for distributing the numbers ..
As for the results provided : 6 - 4 - 5 - 3
But there are other possibilities : 3 - 6 - 5 - 4
and 6 - 4 - 3 - 5
I need it in random way if possible
Thanks a lot for offering help

 

[NARAYANK991]

Hi ,

There is nothing which is not random about a sequence !

It is a mistake we make to think that a sequence is not random.

If you toss a coin 5 times and get heads , is it not random ? After all , given the number of possibilities , 5 heads is also one of them.

The values in columns M through P are listing the available combinations of the unique values in your input data range F3:K6 ; this I have generated manually.

See the attached file for a revised version ; if you don't like the combination presented , press the F9 key till you see another combination.

Narayan

 

[YasserKhalil]

That's great Mr. Narayan ..now I can get any possiblity easily
But what about Column M to Column P.. I didn't want to do it manually !! Is there a way to do the task automatically ?
Another point if possible I need the solution using vba not formulas?
But I liked your solution a lot
Thanks a lot for great help