Hi all,
I have been tasked with creating a document that will pair off members of staff in my building. So far I have managed to make something barely workable (rand, rank, and vlookup), while this technically works, there is the possibility of being paired with oneself. Additionally, I have been told members of the same project cannot pair with each other for integrity reasons, so my question is this: would it be possible to create something that A: creates pairs without self-pairing, and B: disallows the pairing of people in the same project?
As I say, my current version technically works, but refreshing the number randomiser until an allowed list is made takes longer than working it out manually!
Thanks in advance![]()
Bookmarks