simulation, need to assign multiple descriptions without repeating.

[jameshalko]

So unfortunately I can't copy my worksheet here because I'm frankly not allowed, the data is company property so I will try to explain my problem the best I can.

Okay so to begin with; this is for a simulation.
The simulation seeks to assign descriptions to freight. these are designated by Class 50, class 85, class 100, etc.
In addition, there maybe up to 8 classifications depending on random variable and probabilities.

What I am doing now

Please Login or Register  to view this content.

This code is in the class 2 column. So the second description for the freight (every piece of freight has at least 1 class) Basically what it is saying when implemented in the spread sheet is if there are over one classifications for the freight, assign a class in the class 2 column based on a list of probabilities. The problem I am having is that a piece of freight will be given the same classification twice. So it will have class 1= 70 class 2 =70. This could also be class 1=100 class2=125 class3=70 class4=125
This is a problem because the what should have been a piece of freight with multiple classification just became freight with one classification.

So what I need to do is have it say: if this classification was already chosen, rechoose. This way there are no duplicate classifications and the freight is properly (and randomly) described.

[aydeegee]

Hi jameshalko

I understand that you cannot post company information, but if you were to post your own data (which co-incidentally may closely resemble the company information ) it will really help those who would like to help you, but cannot envisage what you require.

Regards
Alastair