Spreadsheet: 115803d1311294028-finding-the-max-value-using-match-match-test
Sheet: Sheet1

# | Date | Time | Close | Highest Close | What It Should Equal
2 | 2001-01-04 00:00:00 | 20:00:00 | 0.9303 | /
2 | 2001-01-04 00:00:00 | 21:00:00 | 0.9291 | /
2 | 2001-01-04 00:00:00 | 22:00:00 | 0.932 | /
2 | 2001-01-04 00:00:00 | 23:00:00 | 0.9416 | /
2 | 2001-01-04 00:00:00 | 1900-01-01 00:00:00 | 0.9458 | /
2 | 2001-01-04 00:00:00 | 01:00:00 | 0.9472 | /
2 | 2001-01-04 00:00:00 | 02:00:00 | 0.9504 | /
2 | 2001-01-04 00:00:00 | 03:00:00 | 0.9465 | /
2 | 2001-01-04 00:00:00 | 04:00:00 | 0.9469 | /
2 | 2001-01-04 00:00:00 | 05:00:00 | 0.9466 | /
2 | 2001-01-04 00:00:00 | 06:00:00 | 0.9473 | /
2 | 2001-01-04 00:00:00 | 07:00:00 | 0.9442 | /
2 | 2001-01-04 00:00:00 | 08:00:00 | 0.9444 | /
2 | 2001-01-04 00:00:00 | 09:00:00 | 0.9465 | /
2 | 2001-01-04 00:00:00 | 10:00:00 | 0.9491 | /
2 | 2001-01-04 00:00:00 | 11:00:00 | 0.9496 | /
2 | 2001-01-04 00:00:00 | 12:00:00 | 0.9489 | /
2 | 2001-01-04 00:00:00 | 13:00:00 | 0.9497 | /
2 | 2001-01-04 00:00:00 | 14:00:00 | 0.9507 | /
2 | 2001-01-04 00:00:00 | 15:00:00 | 0.9532 | /
2 | 2001-01-04 00:00:00 | 16:00:00 | 0.9525 | /
2 | 2001-01-04 00:00:00 | 17:00:00 | 0.9534 | /
2 | 2001-01-04 00:00:00 | 18:00:00 | 0.9534 | /
2 | 2001-01-04 00:00:00 | 19:00:00 | 0.9541 | /
2 | 2001-01-04 00:00:00 | 20:00:00 | 0.9574 | / | What It Should Equal.
3 | 2001-01-04 00:00:00 | 21:00:00 | 0.9559 | 0.9584 | 0.9574 | Highest close between all the #2s in column "A".
3 | 2001-01-04 00:00:00 | 22:00:00 | 0.9549 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-04 00:00:00 | 23:00:00 | 0.9568 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 1900-01-01 00:00:00 | 0.954 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 01:00:00 | 0.9539 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 02:00:00 | 0.9535 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 03:00:00 | 0.9542 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 04:00:00 | 0.9527 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 05:00:00 | 0.954 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 06:00:00 | 0.954 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 07:00:00 | 0.9517 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 08:00:00 | 0.953 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 09:00:00 | 0.9532 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 10:00:00 | 0.9564 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 11:00:00 | 0.9574 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 12:00:00 | 0.9575 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 13:00:00 | 0.9575 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 15:00:00 | 0.9584 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 16:00:00 | 0.9574 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 17:00:00 | 0.9566 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 18:00:00 | 0.9566 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 19:00:00 | 0.9566 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
3 | 2001-01-05 00:00:00 | 20:00:00 | 0.9557 | 0.9584 | 0.9574 | Repeat the highest close from "E27".
4 | 2001-01-05 00:00:00 | 21:00:00 | 0.9566 | 0.9566 | 0.9584 | Highest close between all the #3s in column "A".
4 | 2001-01-05 00:00:00 | 22:00:00 | 0.9563 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-07 00:00:00 | 23:00:00 | 0.9563 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 1900-01-01 00:00:00 | 0.9535 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 01:00:00 | 0.952 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 02:00:00 | 0.9523 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 03:00:00 | 0.95 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 04:00:00 | 0.9491 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 05:00:00 | 0.9485 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 06:00:00 | 0.9486 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 07:00:00 | 0.9506 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 08:00:00 | 0.9485 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 09:00:00 | 0.9483 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 10:00:00 | 0.9482 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 11:00:00 | 0.9496 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 12:00:00 | 0.9485 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 13:00:00 | 0.9469 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 14:00:00 | 0.9467 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 15:00:00 | 0.9464 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 16:00:00 | 0.9448 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 17:00:00 | 0.9445 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 18:00:00 | 0.9451 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 19:00:00 | 0.9442 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
4 | 2001-01-08 00:00:00 | 20:00:00 | 0.9444 | 0.9566 | 0.9584 | Repeat the highest close from "E50".
5 | 2001-01-08 00:00:00 | 21:00:00 | 0.9445 | #N/A | 0.9566 | Highest close between all the #4s in column "A".