Thread: random ABC

Using my phone and can't seem to use the attachment feature. Hopefully I can ecplain it well enough.

Im creating a worksheet for work, we have presses that have 3 stations (AB and C) and anywhere between 3 and 38 cavities. Every few hours a quality tech has to pull 5 random bottles from the press. I have been able to use the RAND feature to get the random numbers for the cavities but can't figure out how to get the 3 stations (ABC) to work.

The worksheet looks something like this

Press. # of cavities.
1. 24. 3. 21. 6. 9. 11. 4. 7. 22. 18. 12.
2. 8. 3. 6. 2. 6. 8. 1. 2. 4. 1. 5.
And so on

The stations ABC need to show up in each colum in front of the numbers but in random order. It would be best if the ABC part could be in order but random like the following

A3 A21 B6 C9 C11
A3 B6 C2 C6 C8
A7 A8 A14 C2 C22

I used the RAND feature in each of the 10 columns from the number put into the # of cavities column.

Any help would be greatly appreciated, thanks!!

That works great except that I need the numbers in each row generated from the number that is in the # of cavities column. What I posted earlier got messed up when I posted it.

Each column looks like this

Press #
1
2
3
And so on...

# of cavities
22
14
8
and so on

Each row of random numbers need to be generated from the number that is in the cavites column. For example the first row can only have numbers 1-22, row 2 can only have numbers 1-14. Thanks for all the help!!