Hi all, Hope once again you can sort out what should be a simple question. I have a sheet with 2 rows of data. In another 2 other rows I have a target values. I would like to find the max value from row 1 from data that is aboe the target value. For the second row of data I would like to find the min value from the data that is above the target value. Will try to show below.
row 1 123 345 342 100 178 453 124
row 2 700 232 500 245 646 157 578
Target value 250
target value 500
So for row 1 I want to find the max value in that row above the target value 250
Row 2 I want the min value above the target vlaue of 500
Hope that makes sense.
row 1 123 345 342 100 178 453 124
row 2 700 232 500 245 646 157 578
Target value 250
target value 500
So for row 1 I want to find the max value in that row above the target value 250
Row 2 I want the min value above the target vlaue of 500
Hope that makes sense.