relaxation
New Member
- Joined
- Nov 8, 2018
- Messages
- 3
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
In my example I've got components of 5 combinations in B5:C9 to be multiplied, Extra is added to each of the B5:B9 and C5:C9 array(s) when calculating the Largest product of those arrays. Instead of listing the results of the multiplication I'd like their Labels from A5:A9 instead as a minimum, however the entire row (example: A7:C7) would be my next step.
I want to reference a much larger combination array but not repeat it in 16 sheets, the Extra values and largest 4 products would be unique to each sheet. I currently have a INDEX/MATCH 16-Item Drop down system currently on one array but further expansion to that gets cumbersome.
<tbody>[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
In my example I've got components of 5 combinations in B5:C9 to be multiplied, Extra is added to each of the B5:B9 and C5:C9 array(s) when calculating the Largest product of those arrays. Instead of listing the results of the multiplication I'd like their Labels from A5:A9 instead as a minimum, however the entire row (example: A7:C7) would be my next step.
I want to reference a much larger combination array but not repeat it in 16 sheets, the Extra values and largest 4 products would be unique to each sheet. I currently have a INDEX/MATCH 16-Item Drop down system currently on one array but further expansion to that gets cumbersome.