I need suggestions on the best way to handle a rather complex set of sorting and assigning. I'm hoping someone has experience doing this sort of thing.

I work for a University and I have to put together pairs of students on 4 separate occasions. Each time the need a different partner and a different faculty member assigned. An example to explain this is shown on the table below.

sample table.jpg

For instance, Dr. Smith gave a test to Phil Hawk in Test 1. I have Phil Hawk with a new partner but he's with the same proctor so I need to change him to another partner.

In reality I have to handle 230 students and 5 faculty professors. It's a lot more complex than this table would show since the students I work with are sometime bundled into different groups. They aren't always the same students over and over again but sometimes they are in the same pool.

I need to randomize the assigned partners and make sure they aren't tested by the same faculty member and by the 4th test it gets very tedious. Does anyone have any suggestions on a way I can make this simple and have either Excel or Access handle all this for me?