Dear all Excel Professionals,
I am a total newbie to excel and wants to know if it is possible to have a auto generator for the grouping.
I have 8 games, max. for 36pax (sometimes will be fewer to 18pax).
I will have 4 groups to do the same game at the same time.
I hope to make a auto generator that all the members can group with different members as much as they can.
Would all of you please help :
1) Is it possible to do with Excel? (Please let me know if it is too complicated to do it in Excel)
2) If possible, anyone can help for the equations or VBA?
Thank you very much in advance.
ray:ray:ray:ray:
I am a total newbie to excel and wants to know if it is possible to have a auto generator for the grouping.
I have 8 games, max. for 36pax (sometimes will be fewer to 18pax).
I will have 4 groups to do the same game at the same time.
I hope to make a auto generator that all the members can group with different members as much as they can.
Would all of you please help :
1) Is it possible to do with Excel? (Please let me know if it is too complicated to do it in Excel)
2) If possible, anyone can help for the equations or VBA?
Thank you very much in advance.
ray:ray:ray:ray:
