I am creating a 100X100 matrix with Euclidean Distance from the master attributes sheet (See attached workbook). The matrix will be created on the Euclidean Distance sheet. The formula that I am using is as follows:
= ((risk of item 1 - risk of item 2)^2 + (cost of item 1 - cost of item 2)^2 + (performance of item 1 - performance of item 2)^2)^(1/2)
I need to compare every item like this and put the result in the corresponding cell of the Euclidean Distance sheet. How could I do this without having manually enter the equation for every item?
Bookmarks