Home Create matrix from predefined cells
Reply: 0

Create matrix from predefined cells

user507
1#
user507 Published in June 21, 2018, 6:29 am

Good afternoon,

I'm quite new to VBA and Excel and i'm having the following problem. I have a function that requires a symmetric matrix as input to calculate the eigenvalue [=MEigenvalueMax (A1: C3)]. However, I have the data for the matrix in different cells. My question is therefore whether there is a function with which I can define predefined cells as a matrix, e. g. =MEigenvalMax ({A1, A2, A3; B1, B2, B3; C1, C2, C3}). Thank you for the answers!

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.270737 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO