Now that I can match the roommates - thank you Jeff! , I'd like to assign the pair a confirmation code that is the same for each of the roommates, but uniquely to the group.
For example Michael and Stepheni matched, so they would have the same code in the ConfirmCode column. It doesn't have to be a number just unique to the list and matched to the pair.
Thank you all for your help!
