It's actually been a while since I've been able to work on this project. I did make some progress will excel's logic, but I had another question that maybe you could help me address. In my experiement I have five different sets of instructions all within one file, out of the first ten scale responses, the odd numbers will dictate which of these sets of instructions the participant skips to. I was able to have excel determine the variable with the highest rating by using a helper table.
I was wondering if there was a way to assign the variable names numeric values that are indepdent of the ratings the participants endorse during the experiment. In other words, when I look at the variables "respon3, respon5, respon7, respon9, respon11" and excel figures out that respon7 is the highest, is there a way to have those responses assigned numeric values 1-5 so that I can use a logic formula similar to this one:
=IF(B13=1,"Q1",IF(B13=2,"Q2",IF(B13=3,"Q3",IF(B13= 4,"Q4",IF(B13=5,"Q5")))))