snowyapril
New Member
- Joined
- Jun 8, 2009
- Messages
- 3
Hi there,
I'm trying to randomize the forms we use for study participants for two different sessions without repeats.
Specifically, at session #1 , participants are randomized to receive Form A, Form B, or Form C of the same measure. For session #2 , we want to randomize what form version they receive so that they are not getting the same form from session #1 . Therefore, if a participant was randomized to Form A at session #1 (from Forms A, B, and C), we want to randomize their receipt of either Form B or Form C at session #2 . If they were randomized to Form B at session #1 , then we would randomize either Form A or Form at session #2 . And so on...
How do I create this in excel without VBA?
Any help would be greatly appreciated. Please let me know if I can answer any clarifying questions. Thanks so much in advance!
I'm trying to randomize the forms we use for study participants for two different sessions without repeats.
Specifically, at session #1 , participants are randomized to receive Form A, Form B, or Form C of the same measure. For session #2 , we want to randomize what form version they receive so that they are not getting the same form from session #1 . Therefore, if a participant was randomized to Form A at session #1 (from Forms A, B, and C), we want to randomize their receipt of either Form B or Form C at session #2 . If they were randomized to Form B at session #1 , then we would randomize either Form A or Form at session #2 . And so on...
How do I create this in excel without VBA?
Any help would be greatly appreciated. Please let me know if I can answer any clarifying questions. Thanks so much in advance!