Quote:
Originally Posted by udea
Value 151 is actually =max(a3:a122)/2, which is at row 23.
|
Actually, the result of that formula is 150.96515. However that makes little difference to the syntax of the formula required for matching purposes.
Quote:
Originally Posted by udea
I said row 7 is the nearest to the value 151 because the value is in the "middle" of row 7 and 8 and is before the peak (row 23).
|
So, you want the nearest match before the average is first reached? What happens if the first value is the maximum?
You need to set out fully what the matching logic is.