Difference between multiple permutation of columns, for several days.

Hi,
I've gone through many things such as array, offset etc. but I can't figure out a robust way to do this...


I have entity A to Z. (my columns)
Each entity has a daily price for say 1 month. (my rows)

I want to work out the difference between each daily price between every entity. (e.g. on 1-Jan-2010: difference in price between A and B, A and C, D and G, P and E etc. all the permutations).
Then the same for every single day.

I think I may need to use a macro/VB to do this?