Excel Formula to assist Speed Dating Event
I'm looking for a formula that would prevent participants at speed dating events from meeting more than once (if I host recurring events once a month). I've been watching basic videos on preventing duplicates in data but none have accounted for every iteration of pairings within two columns (10 men, 10 women). Any advice on alternative formulas to check out or a way to write a more complex formula is greatly appreciated!