Dear collegues,

I'm working on a consumer survey. In this survey, we asked to consumers to rank their three preferred labelling schemes among a pool of ten alternatives.

So, for each consumers, we have his rank 1, rank 2 and rank 3. In the exemple provide below, the consumer 1 ranked the alternative 7 at rank1, the alternative 5 at rank 2 and the alternative 4 at rank 3.

Array

My question is: Do you know how I can generate random variable (value between 1 and 10) without taking the values taken in the previous rows?

For exemple, here, i want to generate a value for the rank 4 between 1 and 10 without taking the value 7, 5 and 2. For the rank 5, generate value between 1 and 10 without taking the value 7,5, 2 and the one generate for rank 4 etc.

I hope I have made myself clear I remain available for any further informations,

Regards

Jean-François DEWALS