I'm not sure if I posted this correctly before. So I apologize if this is a repeat or the wrong place to put this!
But I really need some help...I am having some issues with Randomly Select Names No Repeats Until the list is exhausted. cannot repeat down or across!
But I really need some help...I am having some issues with Randomly Select Names No Repeats Until the list is exhausted. cannot repeat down or across!
I have 4 columns of names, some names (like Sue) are in all columns (P,M,SO,ST) GIVEN THE TASK THAT THEY KNOW HOW TO DO.
for a given month or MORE, each week i must list individuals from the 4 columns that can do the below tasks.
PRESIDENT (P) PRESIDENT (P) MICS (M) MICS (M) SOUND (SO) STAGE (ST)
<tbody>
</tbody>
1/13/2017
1/15/2017
cont'd
Right now I'm using a drop-down list & relying on human error & the countif function NOT to repeat. There has to be an easier way to select from a given column without repeating the names until they have all be used, & also ensuring that the tasks assigned do not repeat the names across (for the given week).
for a given month or MORE, each week i must list individuals from the 4 columns that can do the below tasks.
PRESIDENT (P) PRESIDENT (P) MICS (M) MICS (M) SOUND (SO) STAGE (ST)
1/1/2017 1/6/2017 1/8/2017 |
<tbody>
</tbody>
1/13/2017
1/15/2017
cont'd
Right now I'm using a drop-down list & relying on human error & the countif function NOT to repeat. There has to be an easier way to select from a given column without repeating the names until they have all be used, & also ensuring that the tasks assigned do not repeat the names across (for the given week).