Hello All, I have what I think may be a "simple" IF statement function, but I'm having trouble ensuring the "variable" can be randomaly assigned" to a category (depending on the results of the IF statement). So if you take a look below I'll try to explain. I have a set of survey respondents. The respondents could me a member of 1, 2, or 3 organizations. For analysis purposes, I need to treat each respondent as if they only belong to one organization; So if a person happens to belong to 2 organizations, I want to "randomly" assign them to only one group in which they belong and analyze their data accordingly. For Example,

Column Headings:
Respondent ID Org 1 Org 2 Org 3 Additional Info

Row Data:
123 Yes No Yes abc
321 No Yes Yes cda
432 Yes Yes Yes xyz
532 Yes No No zyx

I want to ensure that the respondent is "randomly" assigned to one of the organizations, but the respondent must actually belong to that organization before being assigned to it.
Logic: Look at respondent 1, check what organizations they belong to, randomly assign the respondent to only 1 organization. **A bonus would be to transfer all the respondent's additional info (in that row) to the new sheet/row/column. ** NOT a necessity though