A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

displaying results of minverse



 
 
Thread Tools Display Modes
  #1  
Old June 24th, 2004, 09:14 AM
Steve G
external usenet poster
 
Posts: n/a
Default 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  
Old June 25th, 2004, 04:08 AM
Jerry W. Lewis
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.