Hello,

I have a large Excel file. I want to compare data from five different
columns in each row. I want to see which of the values is most similar to
the value in another column. It is also possible that the values will be
totally different and not all that similar to one another. I would like to
score this data on a scale, where a value of 1 would indicate similarity to
the first condition with a value of 5 indicating similarity with the last
condition. I know this question may be somewhat unclear---I am just not
really sure how to do this. What I have is a spectrum of values that go up
moving left to right across the sheet, and I want to know where the data in
the next column fits in the spectrum. I could do this by hand, but there are
close to 3,000 rows to go through.

Thanks for any help you can provide!