I am trying to search an unsorted list for the next value that satisfies a certain condition, but am having trouble doing so.
5/26/1977 983.43 27.4081
5/27/1977 979.36 25.0085
5/30/1977 980.31 26.6233
5/31/1977 981.19 28.1664
6/1/1977 982.66 30.7849
6/2/1977 981.24 29.6602
6/3/1977 986.45 38.5336
6/6/1977 983.85 36.087
6/7/1977 984.98 37.9315
To start i have 5/26/1977. I want to then search for the next time that the third column is over 30, and display that date in another cell (i.e. this would then display 6/1/1977).
Any help much appreciated.
Bookmarks