I am a school teacher and we have kids going on a school trip to the snow.
Each child has picked 3 preferences for their "bus buddy".
I am after a way to put this data into excel and run a query against it to tell me which matches work best based on the kids' preferences.
Example below (each...