Randomly Choose a Name from a Household Roster

[Fabla]

hi @Dev
if i get you right by your issue, i have work on a sample file base on the information you have provided below.

@debu_odk

Thank you for response. Maybe I could not make clear which i posted before…I will try to clear.

For example: I need to interview a girl who is between age of 18-25 from a household.

Suppose there are 3 girls between age of 18-25 the named AAA, BBB and CCC in a household.

I can build a household roster using “BEIGN REPEAT” command where I can input all family members.

Now I want to choose a girl for a complete indiviual interview either AAA or BBB or CCC by random

selection with appearance in text like “BBB” is selected (Suppose the “BBB” named girl is selected in random selection).

I mean I want to choose a random name from household roster with text apperance in next screen among of these three girls.

I hope now I can make clearer…could you please tell me about the process?

Dev Maharjan

please test this dev_sample.xlsx (44.9 KB)
sample file and let us know whether it solve you issue or not. sorry for the delay in reply, i just saw it today.

Thanks
fabla2020@gmail.com