Spreadsheet: 116069d1311576611-finding-the-first-greater-value-highest-value-1-
Sheet: Sheet1

# | Date | Time | Close | Highest Close
2 | 2001-01-04 00:00:00 | 20:00:00 | 0.9303 | / | 0
2 | 2001-01-04 00:00:00 | 21:00:00 | 0.9291 | / | 0
2 | 2001-01-04 00:00:00 | 22:00:00 | 0.932 | / | 0
2 | 2001-01-04 00:00:00 | 23:00:00 | 0.9416 | / | 0
2 | 2001-01-04 00:00:00 | 1900-01-01 00:00:00 | 0.9458 | / | 0
2 | 2001-01-04 00:00:00 | 01:00:00 | 0.9472 | / | 0
2 | 2001-01-04 00:00:00 | 02:00:00 | 0.9504 | / | 0
2 | 2001-01-04 00:00:00 | 03:00:00 | 0.9465 | / | 0
2 | 2001-01-04 00:00:00 | 04:00:00 | 0.9469 | / | 0
2 | 2001-01-04 00:00:00 | 05:00:00 | 0.9466 | / | 0
2 | 2001-01-04 00:00:00 | 06:00:00 | 0.9473 | / | 0
2 | 2001-01-04 00:00:00 | 07:00:00 | 0.9442 | / | 0
2 | 2001-01-04 00:00:00 | 08:00:00 | 0.9444 | / | 0
2 | 2001-01-04 00:00:00 | 09:00:00 | 0.9465 | / | 0
2 | 2001-01-04 00:00:00 | 10:00:00 | 0.9491 | / | 0
2 | 2001-01-04 00:00:00 | 11:00:00 | 0.9496 | / | 0
2 | 2001-01-04 00:00:00 | 12:00:00 | 0.9489 | / | 0
2 | 2001-01-04 00:00:00 | 13:00:00 | 0.9497 | / | 0
2 | 2001-01-04 00:00:00 | 14:00:00 | 0.9507 | / | 0
2 | 2001-01-04 00:00:00 | 15:00:00 | 0.9532 | / | 0
2 | 2001-01-04 00:00:00 | 16:00:00 | 0.9525 | / | 0
2 | 2001-01-04 00:00:00 | 17:00:00 | 0.9534 | / | 0
2 | 2001-01-04 00:00:00 | 18:00:00 | 0.9534 | / | 0
2 | 2001-01-04 00:00:00 | 19:00:00 | 0.9541 | / | 0
2 | 2001-01-04 00:00:00 | 20:00:00 | 0.9574 | / | 0 | Below is a long form example of the formula I need.
3 | 2001-01-04 00:00:00 | 21:00:00 | 0.9559 | 0.9574 | 0 | If D27 is >= E27, TRUE
3 | 2001-01-04 00:00:00 | 22:00:00 | 0.9549 | 0.9574 | 0 | If D27 is < E27, AND If D28 is >= E28,TRUE
3 | 2001-01-04 00:00:00 | 23:00:00 | 0.9568 | 0.9574 | 0 | If D27:D28 is < E29, AND If [NAME] is >= E29,TRUE
3 | 2001-01-05 00:00:00 | 1900-01-01 00:00:00 | 0.954 | 0.9574 | 0 | If D27:D29 is < E30, AND If D30 is >= E30,TRUE
3 | 2001-01-05 00:00:00 | 01:00:00 | 0.9574 | 0.9574 | 1 | If D27:D30 is < E31, AND If [NAME] is >= E31,TRUE
3 | 2001-01-05 00:00:00 | 02:00:00 | 0.9535 | 0.9574 | 0 | If D27:[NAME] is < E32, AND If D32 is >= E32,TRUE
3 | 2001-01-05 00:00:00 | 03:00:00 | 0.9574 | 0.9574 | 0 | If D27:D32 is < [NAME], AND If [NAME] is >= E33,TRUE
3 | 2001-01-05 00:00:00 | 04:00:00 | 0.9527 | 0.9574 | 0 | The process continues adding an additional row all the way down…
3 | 2001-01-05 00:00:00 | 05:00:00 | 0.954 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 06:00:00 | 0.954 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 07:00:00 | 0.9517 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 08:00:00 | 0.953 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 09:00:00 | 0.9532 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 10:00:00 | 0.9564 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 11:00:00 | 0.9574 | 0.9574 | 0 | Something Like This!
3 | 2001-01-05 00:00:00 | 12:00:00 | 0.9575 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 13:00:00 | 0.9575 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 15:00:00 | 0.9584 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 16:00:00 | 0.9574 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 17:00:00 | 0.9566 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 18:00:00 | 0.9566 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 19:00:00 | 0.9566 | 0.9574 | 0 | …
3 | 2001-01-05 00:00:00 | 20:00:00 | 0.9557 | 0.9574 | 0 | to here. Then starts again.
4 | 2001-01-05 00:00:00 | 21:00:00 | 0.9566 | 0.9584 | 0 | If D50 is >= E50, TRUE
4 | 2001-01-05 00:00:00 | 22:00:00 | 0.9563 | 0.9584 | 0 | If D50 is < E50, AND If D51 is >= E51,TRUE
4 | 2001-01-07 00:00:00 | 23:00:00 | 0.9563 | 0.9584 | 0 | If D50:D51 is < [NAME], AND If D52 is >= E52,TRUE
4 | 2001-01-08 00:00:00 | 1900-01-01 00:00:00 | 0.9535 | 0.9584 | 0 | If D50:D52 is < [NAME], AND If [NAME] is >= E53,TRUE
4 | 2001-01-08 00:00:00 | 01:00:00 | 0.952 | 0.9584 | 0 | If D50:D53 is < E54, AND If D54 is >= E54,TRUE
4 | 2001-01-08 00:00:00 | 02:00:00 | 0.9523 | 0.9584 | 0 | If D50:D54 is < [NAME], AND If [NAME] is >= E55,TRUE
4 | 2001-01-08 00:00:00 | 03:00:00 | 0.95 | 0.9584 | 0 | If D50:D55 is < [NAME], AND If D56 is >= E56,TRUE
4 | 2001-01-08 00:00:00 | 04:00:00 | 0.9584 | 0.9584 | 1 | The process continues adding an additional row all the way down…
4 | 2001-01-08 00:00:00 | 05:00:00 | 0.9584 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 06:00:00 | 0.9584 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 07:00:00 | 0.9506 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 08:00:00 | 0.9485 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 09:00:00 | 0.9483 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 10:00:00 | 0.9482 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 11:00:00 | 0.9496 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 12:00:00 | 0.9485 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 13:00:00 | 0.9469 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 14:00:00 | 0.9467 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 15:00:00 | 0.9464 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 16:00:00 | 0.9448 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 17:00:00 | 0.9445 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 18:00:00 | 0.9451 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 19:00:00 | 0.9442 | 0.9584 | 0 | …
4 | 2001-01-08 00:00:00 | 20:00:00 | 0.9444 | 0.9584 | 0 | to here. Then starts again.
5 | 2001-01-08 00:00:00 | 21:00:00 | 0.9445 | 0.9584 | 0 | If [NAME] is >= E74, TRUE