Mr. Macropod,



As i explained before, the data is acquired from some type of test and then presented in a graph.

Value 151 is actually =max(a3:a122)/2, which is at row 23. normally we would do it manually by drawing a line on the graph to get the x-value at the intersection of y-value (151). By looking at the data set, the nearest is the value in row 7.

If i can point the data for y-value correctly, then i can calculate the x-value.

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).

I attached the excel file with the graph for your better picture.

Thank you very much for your effort.

Regards,
Udea

Attached Files

Book1.xlsx (17.0 KB, 10 views)

Actually, the result of that formula is 150.96515. However that makes little difference to the syntax of the formula required for matching purposes.
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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]