I have a list of competitors that need to be randomly paired up on another sheet to allocate the initial pairings randomly with each other regardless of any other factors.
I would then need a separate function it to be able to randomly pair the names on another sheet based on names that belong to the same group as each other ie. only pair people from group a with people from group a, people from group b with group b etc
Can anyone help suggest where to look to find out how to do this?
I would then need a separate function it to be able to randomly pair the names on another sheet based on names that belong to the same group as each other ie. only pair people from group a with people from group a, people from group b with group b etc
Can anyone help suggest where to look to find out how to do this?