I have a series of data in the first column (DATA 1) that moves to a maximum value before decaying towards zero. I need to find the row number of a particular value to perform calculations.

When locating the maximum data point, I can readily find the row number as shown in Column D by finding the point where the Data is equal to the maximum and then returning the row # suing the MAX function.

In column A, I have used an IF statement to locate the row number where DATA 1 reaches a value of 2. As the remaining data points are greater than 2, I can use the maximum of the column to return my row number.

My problem can be seen in Column C. In this instance, I am looking for the point where the data reaches nearest 2.6 BEFORE the data moves to its maximum. In this case row 977 is the one I need. However, because of the decay, values at and below 2.6 return again after the maximum is reached (row 2335 and up). So I can't use the maximum of column C to return my row number.

Thanks for the help solving!

When locating the maximum data point, I can readily find the row number as shown in Column D by finding the point where the Data is equal to the maximum and then returning the row # suing the MAX function.

In column A, I have used an IF statement to locate the row number where DATA 1 reaches a value of 2. As the remaining data points are greater than 2, I can use the maximum of the column to return my row number.

My problem can be seen in Column C. In this instance, I am looking for the point where the data reaches nearest 2.6 BEFORE the data moves to its maximum. In this case row 977 is the one I need. However, because of the decay, values at and below 2.6 return again after the maximum is reached (row 2335 and up). So I can't use the maximum of column C to return my row number.

Thanks for the help solving!