Long time lurker, first time poster!

I have a working spreadsheet, but I'm needing to scale it up x100 examples, and I have concerns about my data processing. I figure I need to build an array formula that will process this, but can show an example of the problem.

1. I have a combination of 2 vial sizes. We'll say 17 and 21. I am looking for all combinations of these 2 numbers (up to a point). So in my calculations worksheet, I have a matrix created that multiplies varying combinations of each. See the attached screenshot.

snip2.PNG


2. I then collect the entire matrix of numbers and have it sorted into non-repeating values that are ordered from smallest to largest using the SMALL fx.

The challenge I have is that I actually do this currently with 3 different numbers to combine, and I do it out to 30 multiples of each. I've built a multi-winged matrix to calculate all 2700 cells. It works great and seemingly has no significant effect upon the performance of ONE of these. However, I'm soon to need to scale this up to at least 100 different worksheets in the same workbook. And this calculation won't be the only thing running in the workbook. I am happy that at least only one worksheet would be updated at a time, so recalculation probably wouldn't be as bad as initial opening. However, I'd love to be a great steward of the CPU cycles, in addition to just plain elegance in a worksheet.

I'll be the first to admit that Excel's matrix functions don't seem to do the math I'm looking for. However, I can't imagine a world where this type of basic permutational calculation cannot be accomplished within a single formula. If possible, I'd love to incorporate all the way into the SMALL function so that essentially the input is only Vial1 and Vial 2 and Vial 3, and there are hardcoded multipliers of each, and the output is a multi-cell array sorting from smallest to largest result. Unfortunately, I'm really blanking on my options of how to calculate this all within a hidden array, much less output in order.

Anybody with any thoughts, or maybe rabbit holes I could jump down to learn?

Thank you for all the help over the years!
Kyle