If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
displaying results of minverse
I want to invert a large matrix of about 1000 cells. I have followed the first example provided in HELP / MINVERSE and Excel does provide the correct Formula Result and individual inverse matrix cell results on the gray ARRAY page. The formula does not display the individual cell results to the main worksheet. As I want to move to the MINVERSE of the large (1000) array I will need to output them onto the worksheet to see them.
So my question is.. How do I output the individual cell MINVERSE results to the worksheet for display? Excel97 and ExcelNT |
#2
|
|||
|
|||
displaying results of minverse
Try clarifying your question. I suspect that no one has replied because
no one could understood your question. Jerry Steve G wrote: I want to invert a large matrix of about 1000 cells. I have followed the first example provided in HELP / MINVERSE and Excel does provide the correct Formula Result and individual inverse matrix cell result on the gray ARRAY page. The formula does not display the individual cell results to the main worksheet. As I want to move to the MINVERSE of the large (1000) array I will need to output them onto the worksheet to see them. So my question is.. How do I output the individual cell MINVERSE results to the worksheet for display? Excel97 and ExcelNT |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
displaying query results | Matthew | General Discussion | 0 | June 5th, 2004 02:36 AM |
return results based on multiple conditions | Drabbacs | Worksheet Functions | 3 | May 28th, 2004 11:34 PM |
Qtr results to annual results | Matt Thomas | Worksheet Functions | 1 | May 12th, 2004 03:56 PM |
Retaining results aftering copying and deleting original sheet | Mark | Worksheet Functions | 1 | October 23rd, 2003 07:48 PM |