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
|