Randomize with certain conditions

Occasional Visitor

Hello everyone,

I need to randomize for a study conditions participants.
Each participant should see 4 Videos out of 8 possible Videos.
There are always two versions of the videos, so a participant should only watch one of those two. For example if I have watched Video 1, I can't watch Video 2.

All Videos: Video 1, Video 2, Video 3, Video 4, Video 5, Video 6, Video 7, Video 8
Condition A: Video 1, Video 3, Video 5, Video 7
Condition B: Video 2, Video 4,  Video 6, Video 8
Same content but diffrent condition: Video 1 and 2; Video 3 and 4; Video 5 and 6; Video 7 and 8
At the same time the numbers need to sorted from the least to the greatest.

For example:
Person 1: Video 1, Video 4, Video 5, Video 8
Person 2: Video 2, Video 3, Video 6, Video 7

How can Excel generate me these randomasations with all these conditions included?

Thank you so much your help!



 

1 Reply

@A_Mncube 

Based on my understanding of your requirement, I find nothing complex, as you can see here:

Twifoo_0-1620237515286.png