- #1
manjuvenamma
- 102
- 0
I have a table of numbers say 12 X 12 i.e A1 cell to L12 cell. All of them have numbers filled in.
I have to create another table of identical size. first row and first column numbers are just duplicated in the new table i.e.A1 to A12 (first column) A1 to L1 (first row) cells are just copied into the new table without any changes.
All other cells of the new table are to be populated as follows:
for example: cell corresponding to b9 is to replaced by the product of three numbers (i) b9,
(ii) a9 (first element of the same row) and b1 (first element of the same column).
Another example: j6 is to replaced by the product of j6, a6 (first element of the same row) and j1 (first element of the same column).
I can do this manually by writing formula in each cell. I want to do automatically by writing a formula in one cell and copying the same in all other cells of interest.
Can this be down and how?
I have to create another table of identical size. first row and first column numbers are just duplicated in the new table i.e.A1 to A12 (first column) A1 to L1 (first row) cells are just copied into the new table without any changes.
All other cells of the new table are to be populated as follows:
for example: cell corresponding to b9 is to replaced by the product of three numbers (i) b9,
(ii) a9 (first element of the same row) and b1 (first element of the same column).
Another example: j6 is to replaced by the product of j6, a6 (first element of the same row) and j1 (first element of the same column).
I can do this manually by writing formula in each cell. I want to do automatically by writing a formula in one cell and copying the same in all other cells of interest.
Can this be down and how?