The MatrixToList Function

Available in Sets.xla, a Microsoft© Excel add-in.
Click "MatrixToList", or scroll this page for MatrixToList examples.
Click on another function in the browser window to read about it.
Click a function.

Difference Right Associative Difference Disjoint Union Intersection MakeList MakeSet MatrixToList NMakeList PowerSet SymmetricDifference Union

The MatrixToList Function

The MatrixToList function returns a list with levels of nesting
separated by set braces. Note: The braces are necessary in order
to be able to invert the process by running the MakeMatrix macro.
The function can be called in one of two ways.
  1. From the function browser, above.
  2. Typing the function into directly into a cell.

Examples

Example
Excel column letters--> ABCD
1 2 7 17 MatrixToList(A1:C3)
2 3 11 19 {{2,7,17},{3,11,19},{5,13,23}}
3 5 13 23  
Excel row numbers above        


Example of matrix with holes in it
Excel column letters--> ABCD
1   7 17 MatrixToList(A1:C3)
2 3   19 {{0,7,17},{3,0,19},{5,13,0}}
3 5 13    
Excel row numbers above        


Matrices With Holes

In the example above with the matrix with holes in it, zeros are inserted in
the list positions corresponding to the holes. This is how blank cells are
interpreted by the MatrixToList functionality. Note, zeros are actually not
integer zeros but instead string character 0's.

Created on ... December 29, 2001