placing distinct random values refering to another column Excel

I want to generate random String value that won't be repeated depending on the value in the another column. The dataset is fake and I need to complete segment name for every each customer. I put random names of segments this way:

=CHOOSE(RANDBETWEEN(1;6);$Y$2;$Y$3;$Y$4;$Y$5;$Y$6;$Y$7;)

of course it doesn't take into the account that one customer can be placed only in one segment (in one of RANDBETWEEN value). Do you have any solution how to put a distinct value for every customer? enter image description here