Guest Sal Posted August 12, 2007 Posted August 12, 2007 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
Guest Uncle Grumpy Posted August 12, 2007 Posted August 12, 2007 Re: Expanded matrix in Excel Sal <start1928@yahoo.com> wrote: >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? Not here bucko. Post this to an EXCEL newsgroup.
Guest Pegasus \(MVP\) Posted August 12, 2007 Posted August 12, 2007 Re: Expanded matrix in Excel "Sal" <start1928@yahoo.com> wrote in message news:1186952088.961875.190000@g4g2000hsf.googlegroups.com... > 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 > You will find Windows experts here and Excel experts in an Excel newsgroup.
Guest Rock Posted August 13, 2007 Posted August 13, 2007 Re: Expanded matrix in Excel "Sal" <start1928@yahoo.com> wrote > 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? <snip> Excel newsgroups are under microsoft.public.excel.* Choose an appropriate one and post there. Or from the web interface: http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx Look down the left side to microsoft.public.excel and expand that section for a list of the newsgroups. Good luck. -- Rock [MS-MVP User/Shell]
Recommended Posts