I have a table of numbers say 12 X 12 i.e A1 cell to L12 cell. All of them have numbers filled in.(adsbygoogle = window.adsbygoogle || []).push({});

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?

**Physics Forums - The Fusion of Science and Community**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Excel spread sheet : related to formula copying

Loading...

Similar Threads - Excel spread sheet | Date |
---|---|

Ratio of Fields from Different Sheets in Excel Pivot | Jan 23, 2018 |

Equivalent to Joining tables (SQL) in Excel? | Jan 22, 2018 |

Excel: Inserting many Horizontal rows in same Cell | Nov 24, 2017 |

Help with Annoying Stuff on Excel | Jan 13, 2017 |

Spread the rumor-Samsung does not have actual HD DVD players | Aug 25, 2008 |

**Physics Forums - The Fusion of Science and Community**