Generate random list of household members

Hello community!

I was wondering if anyone had any ideas on how to do the following:

After I create a roster for a household, I want to randomly select members for further surveying. I already know how to randomly select one member, but in practice, that first person you randomly select may not be available for questioning.

Is there a way to create a random list of household members based on eligibility criteria? This way if #1 on the list cannot interview, then you can follow up with #2 and so on.


Hi @jsleiva
Just following up if you found a solution for this? Nevertheless, I created the following file that randomly selects two people so you have your replacement order incase the first one does not work. Have a look at it.
RandomSelection.xls (33 KB)

1 Like