How do I keep the same names from coming up on the same column when they are randomly generated? I'm trying to integrate this into =IF(Override!G5>0, Override!G5, Shuffle!A34) formula.


name 1
name 2
name 3
name 1 <---if that happens I want this cell to respond by reshuffling until it equals a name that is not in its column.

--------------------------------------------------------------------------------