|Thats brilliant, I will ask then, thanks|
I would like to know which function to use in excel to get the first data point from the 2nd column of a table, when the values in the 1st column have increased above 1 and stayed above 1 in all subsequent cells in the list.
i.e. what do I put between the ? ? in this V lookup formula or is there another way?
In the data set below, the resultant value would be 8
0.9 , 3
1.0 , 4
1.1 , 5
0.9 , 6
0.9 , 7
1.0 , 8
1.1 , 9
1.2 , 10
Thanks in advance for any helpful responses