I'm trying to set up a game of assassins which requires everyone on a list to be given a person to go after with a sock. There is a one to one pairing with no repeats but if i have someone they don't necessarily have me. I'm trying to make an excel spread sheet to give me a randomly generated pairings but I'm having troubles. I found a random number generator so I can generate a random number for each person that will never repeat one above it but I can't figure out how I can basically add a =A before it in the cell so that instead of a number it will reference a cell (The names are in A1-Ax). I've tried to use macros but with minimal luck. What is the best way of doing this? I have like 300 people to pair up and it is critical that it is random and non repeating.