I hope you are well. I have seen this post on random numbers and I hoped someone could help me with my problem. I am trying to get 40 non-repeated random numbers that will corresponds to the households that will be sampled. Once these numbers are calculated, I would like to display them on the same ODK page, so that I don't have to scroll through 40 pages. I currently have the calculation as shown in the attached excel file. Does anyone know how to solve this problem?
Thank you in advance for your help
Test_villagesampling .xlsx (10.1 KB)