excel - pop a random value from a list of cells -

i have question similar this one, little different:

let's have data this:

car name   color  list of colors car1         ?        red car2         ?        blue car3         ?        green car4         ?        black

and want randomly distribute of colors of 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 way have cell randomly select list excluding values input in range?

in d2 enter:

=rand()

and copy down. in b2 enter:

=index(c$2:c$5,match(large(d$2:d$5,row()-1),d$2:d$5,0))

and copy down:

TSQL