Hello!
I have in the cells I4:I23 the variable y, and in the B4:B23 the variable x. I want to put in the cell L4 the maximum value of the I4:I23 and in the cell M4 the variable x that corresponds to that maximum(so if my maximum value was at cell I6 I want to appear in the cell M4 the value of B6). Then I want to drag the formula down so that in the cell L5 appears the maximum of the I27:I46 and at the cell M5 the variable x that corresponds to that maximum taken from the cells B27:B46. And so on (I want to drag it down for more maximums and corresponding x's)
Thank you
I have in the cells I4:I23 the variable y, and in the B4:B23 the variable x. I want to put in the cell L4 the maximum value of the I4:I23 and in the cell M4 the variable x that corresponds to that maximum(so if my maximum value was at cell I6 I want to appear in the cell M4 the value of B6). Then I want to drag the formula down so that in the cell L5 appears the maximum of the I27:I46 and at the cell M5 the variable x that corresponds to that maximum taken from the cells B27:B46. And so on (I want to drag it down for more maximums and corresponding x's)
Thank you