mardi 29 septembre 2015

pop a random value from a list of cells

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