Randomize with certain conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-2326170%22%20slang%3D%22de-DE%22%3ERandomize%20with%20certain%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326170%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20everyone%2C%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20need%20to%20randomize%20for%20a%20study%20conditions%20participants.%3CBR%20%2F%3EEach%20participant%20should%20see%204%20Videos%20out%20of%208%20possible%20Videos.%3CBR%20%2F%3EThere%20are%20always%20two%20versions%20of%20the%20videos%2C%20so%20a%20participant%20should%20only%20watch%20one%20of%20those%20two.%20For%20example%20if%20I%20have%20watched%20Video%201%2C%20I%20can't%20watch%20Video%202.%3CBR%20%2F%3E%3CBR%20%2F%3EAll%20Videos%3A%20Video%201%2C%20Video%202%2C%20Video%203%2C%20Video%204%2C%20Video%205%2C%20Video%206%2C%20Video%207%2C%20Video%208%20%3CBR%20%2F%3E%20Condition%20A%3A%20Video%201%2C%20Video%203%2C%20Video%205%2C%20Video%207%20%3CBR%20%2F%3E%20Condition%20B%3A%20Video%202%2C%20Video%204%2C%20Video%206%2C%20Video%208%20%3CBR%20%2F%3E%20Same%20content%20but%20diffrent%20condition%3A%20Video%201%20and%202%3B%20Video%203%20and%204%3B%20Video%205%20and%206%3B%20Video%207%20and%208%20%3CBR%20%2F%3E%20At%20the%20same%20time%20the%20numbers%20need%20to%20sorted%20from%20the%20least%20to%20the%20greatest.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20example%3A%20%3CBR%20%2F%3E%20Person%201%3A%20Video%201%2C%20Video%204%2C%20Video%205%2C%20Video%208%20%3CBR%20%2F%3E%20Person%202%3A%20Video%202%2C%20Video%203%2C%20Video%206%2C%20Video%207%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20How%20can%20Excel%20generate%20me%20these%20randomasations%20with%20all%20these%20conditions%20included%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20so%20much%20your%20help!%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2326170%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2327876%22%20slang%3D%22en-US%22%3ERe%3A%20Randomize%20with%20certain%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2327876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1045725%22%20target%3D%22_blank%22%3E%40A_Mncube%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20on%20my%20understanding%20of%20your%20requirement%2C%20I%20find%20nothing%20complex%2C%20as%20you%20can%20see%20here%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Twifoo_0-1620237515286.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278508i1C9FE5FD2158CBE7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Twifoo_0-1620237515286.png%22%20alt%3D%22Twifoo_0-1620237515286.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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