Hi folks
The attached sample sheet gives a target number in A2.
Col B lists various combinations of numbers (always 4 numbers)
Cells C1:H1 display the numbers that are LOWER than our targeted number (7)
Cells C2:H2 show a value for each of the numbers (1 to 6) that are lower than (7)
What I want to do from Col B is find every Cell with our targeted number (7) and then show the PRODUCT of the number/s (from the value cells for each) lower than our target.
Our targeted number will never be the first number, but can be 2nd, 3rd or fourth number but will not repeat in the same cell.
We have no interest in this sample for numbers 8 and above.
In Row 3 I have just manually input the values from numbers 1,2,3 and shown the product in Cell I3 to show what I want to achieve.
Hope that makes sense.
Cheers
Hammer
Bookmarks