Help with an Excel Formula

Maj786 

I found this question addressed to me on my email notification though not within the discussion itself.

"What if I had more than 3 rows?"

Since 2016, I have programmed Excel using array formulas only (originally using CSE, which was a pretty dreadful experience when you required flexibility).  Typically a formula I write for 3 rows will also work for 36.  What it will generally not cope with is a varying number of cells per 'scenario'.  It is possible, but it is likely that greater effort will be required to identify the data objects than for the subsequent calculations.