Hi!

I hope someone will help me with the following question. I am trying to make a task in which words from two different word categories will appear randomly on the screen. In total we have 80 words; 20 from category 1 and 20 from category2; each word is repeated twice. I want these 80 words in my task; so no missings or words that are repeated three times.

A restriction of this randomization is that we want that three words from the same category never appear subsequently. Another restriction is that we do not want the same words occur in succession.

I have managed to organize the word lists randomly. However, I don’t know how to say IF C2 AND C3 AND C4 are all words from category1 THEN take another word randomly from the list and replace C4. And continues this loop until C4 is a category 2 word.

An additional problem is that it is possible that at the end from the list I only have 3 words from the same category. Is it possible that excel repeat the whole function until the whole list is completed?

All suggestions are welcome!

Best,
Bloem