Can you share your spreadsheet as "view only", so I can take a look at a sample of the data to understand it better? (e.g. if you don't want to, please create a spreadsheet with bogus data and the same structure)
–
Henrique AbreuMay 2 '12 at 22:43

Will this generate one row for each value under the diagonal? i.e. the combination of all questions against all others? Isn't this table arrangement better to look and find results?
–
Henrique AbreuMay 3 '12 at 18:48

Such formula is too difficult for me to come up without spending long hours thinking about it. Sorry.
–
Henrique AbreuMay 3 '12 at 18:59

thanks for the look. yes the idea was to simply rank them by correlation, what you want is simply to know where the strongest links are. I'm thinking you'd have to do it in several steps with fancy indirects but still not sure how to get them all into a single array.. thanks again
–
heorlingMay 3 '12 at 22:25