All Possible Combinations

Default Keys: Ctrl + Shift + Alt + M

This Nutility will give you all possible combinations of values within columns.

For example. When you run the Nutility, a popup will ask you to select the range you want all combinations of. If you highlighted a range like the light-green box below, a new sheet will be created in the workbook with the values shown in the blue box.

You are not limited to 3 columns. You can use 2 to as many columns as you want.

NOTE: This Nutility ignores blanks cells. However, no column within your selected range can be entirely blank.

This Nutility requires you to have the Nutilities Excel add-in installed in order to use it. If you don’t know what Nutilities is, or where to get it, please start at my web-page here: http://iwishexcel.com . The add-in is completely free to use.

Leave a Reply

Your email address will not be published. Required fields are marked *