The big boss wants to average all combinations of 2 sets of 3 numbers - so he wants the average of 485 and 952; 485 and 740; and 485 and 219, for example. We started off with the plain old =AVERAGE($A4,B$3) and filled in the rest of the cells. But he wanted something like a pivot table (????) or a matrix function from linear algebra (????). Any help would be greatly appreciated!
...........952 740 219
485
210
357
We're using Excel 2003 and Windows XP.
...........952 740 219
485
210
357
We're using Excel 2003 and Windows XP.