The NMakeList Function

Available in Sets.xla, a Microsoft© Excel add-in.
Click "NMakeList", or scroll this page for NMakeList 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 MakeList Function

The NMakeList function returns a simple list.
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.

Example

Excel Column Letters--> ABC
1 1 4 NMakeList(A1:B3)
2 2 5 1,4,2,5,3,6
3 3 6 NMakeList(A1:B3,3)
4     1,4,2,5,3,6,1,4,2,5,3,6,1,4,2,5,3,6
Excel Row Numbers Above      


How it differs from MakeList

In the example above, in cell C2, NMakeList is not called with
the optional integer argument and so therefore behaves like
MakeList would behave. However, in cell C4, the same string
"1,4,2,5,3,6" is repeated 3 times. This is because
the optional integer argument of 3 instructs it to do so.

Created on ... December 29, 2001