Quote Originally Posted by martindwilson View Post
in m2 you have 71 if this relates to star 28 ie value in chosen 1 I2 is 28 which corresponds with d2 why is the result not
28 star 64
from t112
Thank you for your response! I apologise if I didn't make myself clear in the original post! Column R stands for subjects (the same as the column A). So, what I'm interested in is what is the corresponding rating (reported1) for the most chosen symbol (chosen1). Here the 28 in M2 stands for star in D2-G2, so we look up the value for participant 1, star, which turns out to be 71.

Also I have noticed that sometimes the order is impossible to work out. E.g. In cases where either reported or chosen frequencies have multiple occurrences of one value. I was able to solve this problem by highlighting the part in question when to be able to make an adjustment if necessary. I'm not sure though if it is possible to do the same in an automated procedure.