I'm using microsoft office excel 2007.
I have a column of vendors and I have a column of prices.
I want to see what each vendor's price is relative to the other vendors' prices.
I can't seem to find a quick way of doing it without just plugging in the formulas...
I've tried pivot tables... but they appear to be more for data sorting...
some example data would be:
Vendor's: A,B,C,D
Prices: 5,10,15,20

what I would like to see is:
A/B/C/D
A 1/2/3/4
B .5/1/1.5/2
C .33/.66/1/1.33
D .25/.5/.75/1

can you suggest how i might do this without typing in the individual formulas into each cell?
thanks,