MEIGENVEC(squared_matrix)
MEIGENVEC(squared_matrix) returns the eigenvectors for a squared matrix entered as a range or array.
In the screenshot below, the squared matrix is contained in the cell range A1:C3. Cells E1:G3 contain the MEIGENVEC function entered as an array. If squared_matrix is of size m x m, and =MEIGENVEC(squared_matrix) is entered in array form in an m x 1 cell orientation, the first eigenvector will be returned. If squared_matrix is of size m x m and =MEIGENVEC(squared_matrix) is entered in array form in an m x 2 cell orientation, the first and second eigenvectors will be returned, etc. For example, in the screenshot below squared_matrix is of size 3 x 3 and contained in the range A1:C3, =EIGENVEC(A1:C3) entered in array form in cells E1:E3 will return the first eigenvector, =EIGENVEC(A1:C3) entered in array form in cells F1:F3 will return the second eigenvector and =EIGENVEC(A1:C3) entered in array form in cells E1:G3 will return all three eigenvectors.