I have a question that is similar to this one, but a little different:
Let's say I have data like this:
CAR NAME COLOR LIST OF COLORS
Car1 ? Red
Car2 ? Blue
Car3 ? Green
Car4 ? Black
and I want to randomly distribute all of the colors to all of the cars without repetition, i.e.
CAR NAME COLOR LIST OF COLORS
Car1 Green Red
Car2 Black Blue
Car3 Blue Green
Car4 Red Black
Is there a way to have a cell randomly select from a list excluding values already input in another range?
Aucun commentaire:
Enregistrer un commentaire