Forum Discussion
Can Excel generate a unique code from response patterns?
I am working with survey response data within an Excel worksheet. Most of the survey answers are words, or a binary 1/0 (indicating whether or not the respondent selected the response). I need to cre...
ibitarJr You do not mention what problem you are facing to gain your desired output. Give a try on below formula-
=CONCAT(SEQUENCE(,10)&B2:K2)
hI Harun24HR thanks for speedy reply. formula returned a #name? error (I had to change cell references from B2:K2 to AF2:AO2
I need a way to group survey respondents into groups by their preference responses. Once grouped, I can use this group as an independent variable in linear regression analysis against the other categorial variables.
