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)