Obtaining set of outputs for multiple sets of inputs

**rypalan** · 09-30-2019, 07:33 AM

I've written a certain algorithm which takes say 10 inputs (in 10 adjacent cells), does some calculations and provides say 12 outputs. For testing the algorithm, I am able to specify each combination of these 10 inputs, get the 12 outputs and copy them in a different worksheet, but I need to run say 100 different combinations of these 10 inputs. If I can provide these inputs in a 10 columns*100 rows format, is there a way to get output in 12 columns*100 rows format ?

Thanks in advance.

Raj

**Bernie Deitrick** · 09-30-2019, 09:40 AM

Let's say that your algorithm takes the values from cells A2:J2 (10 cells in one row), and outputs values into cells K2:V2 (12 cells of the same row), and that your 100 different combinations are in cells A5:J104, and your algorithm is run by the macro "RunAlgorithm". Then run a macro like this:

Please Login or Register  to view this content.

**MrShorty** · 09-30-2019, 10:13 AM

If I understand what you are doing, a data table can also do this. See example here: https://www.excelforum.com/excel-for...l-formula.html

**rypalan** · 09-30-2019, 12:03 PM

Thanks Bernie. My algorithm is currently not in a macro, it's across some 30 columns and 50 rows. Any chance I can make this work without porting it into macro ?