Best way for differencies cross matrix biulding

[Alexander_Golinsky]

Hi again! Please...

I have a list of cars and cars' prices. what i need is to build cross matrix, meaning:

in the head row - cars names, in the head column - same cars names, inside the matrix, as values, simple diffencies in prices of two cars. Visualisation:

a b c d
a 0 -5 -1 -3
b 5 0 -8 -9
c 1 8 0 -4
d 3 9 4 0

Again: values inside are just one car price - another car price.

This is just an example. Real case is much more complex. That's why i need to know what is the best practice to build such matricies. Thanks in advance!

[Melvinrobb]

Can you post a sample workbook with Mock Data, including a visual of what you want your final product to look like, giving specific examples?

[Alexander_Golinsky]

Thanks for replying, Melvinrobb! I cant upload anything due to restrictions.

I guess description above is clear and what i hope for is that most advanced members would explain conceptually what they whould do.

[Melvinrobb]

You don't have to post the real data. just a sample of similiar type data (replace names with AA, BB - replace the actual numbers with fake numbers).
It is the best way to get a visual of what you are looking for. It also helps to explain what you want any formulas to accomplish (Ex. in A3 the formula would return XX because......)