Creating a macro by using Excel
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 *** |
Creating a macro by using Excel
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 *** |
All times are GMT +1. The time now is 08:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com