Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default matrix

how to I write out a matrix as fast as possible in excel

example
a b c

a 1 2 3

b 2 3 4

c 6 7 8

to


a a 1

a b 2

a c 3

b a 2

b b 3

b c 4

c a 6

c b 7

c c 8

lennie

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matrix Problem Jeff Excel Discussion (Misc queries) 1 February 4th 06 07:36 PM
Matrix calculation Maarten Excel Discussion (Misc queries) 3 September 29th 05 03:29 PM
How to identify entries in a matrix also present in another list larkindale Excel Worksheet Functions 2 September 16th 05 07:07 PM
Limits of MINV matrix function KJ Excel Worksheet Functions 2 September 16th 05 09:06 AM
CORRELATION / COVARIANCE MATRIX Walker Excel Worksheet Functions 1 April 30th 05 06:36 AM


All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"