Hi,
I would like to create a macro by using Excel. The conditions are as
follows:
1.Have 10 groups and 10 subjects.
2.Each group has 10 choices to select the subjects according to its
preference (from most perferred to least perferred one).
4.It must be fair to every group.
5.If two groups choose the same choice,then it will use random method to
decide the final outcome.
6. Try to maximize the chance of every group to get its first few
preferred choices.

Would you please kindly advise me how to create this macro by using
Excel? Thank you very much.

Best Regards,
Claudia



*** Sent via Developersdex http://www.developersdex.com ***

Hi Claudia

i'm not sure how to approach this using a macro, however, i do have a sample
workbook showing two methods using formulas to determine the subject each
group should be awarded - if you're interested email me direct at julied_ng
at hcts dot net dot au.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Claudia L" wrote in message
...

Hi,
I would like to create a macro by using Excel. The conditions are as
follows:
1.Have 10 groups and 10 subjects.
2.Each group has 10 choices to select the subjects according to its
preference (from most perferred to least perferred one).
4.It must be fair to every group.
5.If two groups choose the same choice,then it will use random method to
decide the final outcome.
6. Try to maximize the chance of every group to get its first few
preferred choices.

Would you please kindly advise me how to create this macro by using
Excel? Thank you very much.

Best Regards,
Claudia



*** Sent via Developersdex http://www.developersdex.com ***