VBA/Macro/Formula For Computing All Possible Combinations From Different Lists of Data

**samsmith123** · 10-06-2019, 11:52 PM

Hello,

ExcelScreenshot.PNG

I have about 19 input cells of data from which I am trying to compute the output cells. The data in each input column goes from 0.01 to 0.1
I am trying to find a way to compute the result for all the different combinations of the input cells without any combination repeating.

For eg. If X1 is 0.01, then each of the other input cells X2...X19 have different numbers.

Thanks and much appreciated

**Pepe Le Mokko** · 10-07-2019, 02:48 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

VBA/Macro/Formula For Computing All Possible Combinations From Different Lists of Data

LinkBack

Thread Tools

Rate This Thread

Display

VBA/Macro/Formula For Computing All Possible Combinations From Different Lists of Data

Re: VBA/Macro/Formula For Computing All Possible Combinations From Different Lists of Data

Thread Information

Users Browsing this Thread

Similar Threads

Combinations from 4 lists with conditions

[SOLVED] Formula/Macro to put data into lists

[SOLVED] Combining two lists of names and all combinations based on a separate common value

[SOLVED] Macro computing average and Q1 and Q3 of raw data

Formula (or macro?) to show all number combinations

[SOLVED] Help Required: Stock lists - Calculating combinations of products

Formula or Macro to calculate combinations which produce whole numbers

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions