need to keep the two same names out of 1 column

[Don Juan]

I'm randomly generating names to a few columns. I'm using offset. I've got a formula, =OFFSET(Roster!F$11,MOD(E1,$G$1)+1,0) refering to g1 to count the number of people in my list that will be randomly generated. Say i've got 10 cells to produce names to, but only 5 people on my list. It will fill the empty 5 with the same names again. This is what I want it to do, but what I dont want is for the same names to be put in the same column.

column 1

John <------
Jerry
john <-----
James

column 2

Jim
Jack this column is ok
John
Jerry

[Bryan Hessey]

The lists at Roster!A78 and Shuffle!A1 are randomly sequenced editions of your available personel. Each name supplied appears once only in the list, therefore it would be impossible to produce 'doubles' unless the original personel lists were incorrect.

This same process should be used for the Unqualified personel at F12, random sequence them into a third list and select the names from that area. This will achieve what you ask.

---

I'm randomly generating names to a few columns. I'm using offset. I've got a formula, =OFFSET(Roster!F$11,MOD(E1,$G$1)+1,0) refering to g1 to count the number of people in my list that will be randomly generated. Say i've got 10 cells to produce names to, but only 5 people on my list. It will fill the empty 5 with the same names again. This is what I want it to do, but what I dont want is for the same names to be put in the same column.

column 1

John <------
Jerry
john <-----
James

column 2

Jim
Jack this column is ok
John
Jerry

[Don Juan]

the watch bill is doing two things it shouldn't. One, its generating double names into the watchbill even though there are more names on the roster than spaces to fill in the watchbill. Two, its putting the names in the same column under the unqual watches. I uploaded it for you to see.
The unqual generator is on the shuffle sheet. The qual generator for roster!a11 is on the roster sheet.

[Bryan Hessey]

the watch bill is doing two things it shouldn't.

Computers do that, it's so infuriating

One, its generating double names into the watchbill even though there are more names on the roster than spaces to fill in the watchbill.

The idea was for the available names to be sorted into a randomly sequenced list, and from that list you allocate each cell to a cell on the watchbill. Then there can only be duplicates if you allocate the same randomly sequenced cell to more than one watchbill cell. The formula does not 'generate double' - it simply randomly sequences the list as given.

Two, its putting the names in the same column under the unqual watches.

same answer - the shuffle should simply randomly sequence the available names, and you allocate the cells within the shuffle list to your watchbill.

I uploaded it for you to see.
The unqual generator is on the shuffle sheet. The qual generator for roster!a11 is on the roster sheet.

If you allocate the cells from the randomly sequenced list once only there should be no problem.
---