Picking names from a hat in Excel?
 

Hello all,
I am trying to come up with a way to randomly pick names from a column
based on a criteria. I am referring to this just as if you were
picking names out of a hat. The columns I have will be "A+,A-,B+,B-,C
+,C-,D+,D-". To make the picks fair, for instance, if a "A+" person is
picked, then the following players should be "B-,C+,D-". In addition,
once a person is picked from that column, they cannot be picked again.
There will be various numbers of people in each column as well. I
would need the spreadsheet to run through all the "A+" pairings first
then just to the "A-" columns and adjust accoringly (ie B+,C-,D+
players). I have looked at the rand and index functions, but I cannot
seem to come up with a way to run the program and produce the results
on a seperate sheet.
Any help would be greatly appreciated.