MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro Challenge


Posted by Jimbo on December 10, 2001 5:44 PM

Hi Group! Any help with a macro for this would be great.
Problem. A spreadsheet of sports competitors (competitor number, name, event scores and total score) has to be divided into five winning divisions from highest score to lowest score then 1st & 2nd from each division with scores , name etc. to be displayed.
In the event the number of competitors is not divisable by a whole number then the remainder are to be added to the bottom division/s eg. 40 competitors equals 5 divisions of 8 competitors. Or (if can't be divided by a whole )42 competitors equals top 3 divisions of 8 and bottom 2 divisions of 9.
any help greatly appreciated. Greetings from Australia!


Posted by Juan Pablo G. on December 11, 2001 6:07 AM

I think we need some more numbers to work with... care to post what you have and what you want in small examples ?

Juan Pablo G.