Hi,
I am trying to work out a formula to find the minimum value of from the sum of two rows which match a value in a column as per below.
Screenshot 2023-02-03 084244.jpg
For instance, if i enter in a separate cell "AA2A1" then it would work through columns C to J and calculate the sum of Rating less the Load and then return the minimum value of this calculation within this array and display the rating and the load in separate cells as per below.
Screenshot 2023-02-03 084639.jpg
I've gotten this far with the following formula but i just can't get to the next step: =SUM(INDEX(D4:D11205,MATCH(1,($Y$4=B4:B11205)*("Rating (A)"=C4:C11205),0)),(-1*INDEX(D4:D11205,MATCH(1,($Y$4=$B$4:$B$11205)*("Load (A)"=$C$4:$C$11205),0))))
Any help will be greatly appreciated.
Thanks
Bookmarks