ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Expanded Matrix in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/153920-expanded-matrix-excel.html)

Sal[_2_]

Expanded Matrix in Excel
 

Hi:

Trying to create an interpolation(formula available) matrix using time
(rows , i.e 1,2..10) and the type (Item a, b, c, d) so that the
expanded matrix shows values in increments of 0.01, i.e.
1.01,1.02,1.03 etc. for each a, b, c, d. Can anyone help?

Thanks in advance

a b c d
1 1 2 3 4
2 2 4 6 8
3 6 12 18 24
4 9 18 27 36
5 14 20 30 40
6 20 22 33 44
7 30 24 36 48
8 46 26 40 53
9 68 29 43 58
10 103 32 48 64



All times are GMT +1. The time now is 07:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com