May 05 2021 05:41 AM
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!
May 05 2021 11:03 AM
Based on my understanding of your requirement, I find nothing complex, as you can see here: