Can anyone help with a formula or code that would automatically place individuals into their 1st, 2nd, or 3rd choice of program based on the following:
The individual with the highest score determines the priority of placement
There are a maximum number of placements for each program
Placement...