Gentlemen-
I would very much appreciate some help setting up a formula to apply to a grid of numbers.
Ex:
A B C D E
1 2 3 4 5
1 9
2 8
3 7
4 6
What I'd like to do is input a formula ONCE and copy/paste so it applies to the whole grid, returning the result in the intersecting cell of the column and row.
For instance, the product of 1x9 would display in the intersecting cell of the 1 and 9; the product of 5x6 would be displayed in its corresponding intersecting cell.
This is really easy to accomplish by cutting and pasting by rows, but I'm dealing with several 250x250 matrices, and a one-time cut and paste shortcut would really help. Thank you!
Steve
I would very much appreciate some help setting up a formula to apply to a grid of numbers.
Ex:
A B C D E
1 2 3 4 5
1 9
2 8
3 7
4 6
What I'd like to do is input a formula ONCE and copy/paste so it applies to the whole grid, returning the result in the intersecting cell of the column and row.
For instance, the product of 1x9 would display in the intersecting cell of the 1 and 9; the product of 5x6 would be displayed in its corresponding intersecting cell.
This is really easy to accomplish by cutting and pasting by rows, but I'm dealing with several 250x250 matrices, and a one-time cut and paste shortcut would really help. Thank you!
Steve