Inverse of a Complex Matrix 1

[sdlloyd]

I am using MSExcel XP Pro and I would like to find the inverse of a matrix containing complex numbers. I have managed to find the complex functionality in excel but it would seem that excel's matrix functions only accept real numbers.

Any help or suggestions gratefully received.

 

[SkipVought]

sdlloyd,
Wow! It's been over 35 years since I've worked with complex numbers, but I love the challenge.

Give me a small example, real and complex and what method you are using to transpose the matrix. I'll take a look at it.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[sdlloyd]

Skip

Thanks for your interest.

The information in this pdf has listings and more than I could ever explain.

http://www.nag.com/numeric/cl/manual/pdf/F01/f01_intro.pdf

The document is several layers deep and should be helpful if you have the energy to root around in it. There are examples in the document as well.

 

[sdlloyd]

I have managed to answer my own problem and thought that I would share it with you all.

A search on the web found me this site.

http://digilander.libero.it/foxes/SoftwareDownload.htm

They have freeware XLA files for complex matrices and a whole load of other functions that are going to help me.

My thanks to Skip and anyone else that may have been looking to help.

 

[KenWright]

Many thanks for the link, it looks quite interesting from a cursory glance.

Regards
Ken............