Hello,
My apologies if this has been asked before. I read through several threads and can't seem to find exactly what I need. Basically, in column A, there is a list of locations in groups of two that the names in column B are assigned to in pairs. The list in column B is larger than the locations in column A. I need to find a way to randomly generate a column that takes two names from column B and excludes the second entry in column A so the same name isn't assigned two times in a row nor assigns what was in column C:
A B C D
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
My apologies if this has been asked before. I read through several threads and can't seem to find exactly what I need. Basically, in column A, there is a list of locations in groups of two that the names in column B are assigned to in pairs. The list in column B is larger than the locations in column A. I need to find a way to randomly generate a column that takes two names from column B and excludes the second entry in column A so the same name isn't assigned two times in a row nor assigns what was in column C:
A B C D
<colgroup><col><col><col><col></colgroup><tbody> </tbody> The additional names in column B are excluded if there aren't enough locations from column A but need to be assigned the next time locations are chosen randomly. I hope this makes since. Thank you so much in advance. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>