I have a spreadsheet with 3 columns (DATE, HIGH, LOW).
For each row I want to search the LOW column upwards in order to find the first value for which
x[n-i] <= x[n] - 5 I am looking for a) the difference DATE[n] - DATE[n-i] b) the difference between x[n] and the highest HIGH value in rows n to n-i Date High Low 28/02/07 6286 6166 27/02/07 6435 6271 26/02/07 6447 6402 23/02/07 6402 6357 22/02/07 6416 6357 21/02/07 6430 6352 20/02/07 6448 6392 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
