Spreadsheet: 474724d1470867419-returning-greatest-and-lowest-value-involving-index-match-formula-sample
Sheet: Results

 |  |  |  |  |  |  |  |  |  | PO# |  |  |  |  |  |  | Amount - Open |  | Close Order
 |  |  |  |  |  |  |  |  |  | 379604 |  |  |  |  |  |  | -8050
 |  |  |  |  |  |  |  |  |  | 379604 |  |  |  |  |  |  | 8050 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 382208 |  |  |  |  |  |  | 4751
 |  |  |  |  |  |  |  |  |  | 386476 |  |  |  |  |  |  | 4958
 |  |  |  |  |  |  |  |  |  | 394169 |  |  |  |  |  |  | -2276
 |  |  |  |  |  |  |  |  |  | 394169 |  |  |  |  |  |  | 2276
 |  |  |  |  |  |  |  |  |  | 402702 |  |  |  |  |  |  | -9183
 |  |  |  |  |  |  |  |  |  | 402702 |  |  |  |  |  |  | 11618 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 423558 |  |  |  |  |  |  | -680
 |  |  |  |  |  |  |  |  |  | 423558 |  |  |  |  |  |  | 850
 |  |  |  |  |  |  |  |  |  | 427670 |  |  |  |  |  |  | -766.56
 |  |  |  |  |  |  |  |  |  | 427670 |  |  |  |  |  |  | 816.56
 |  |  |  |  |  |  |  |  |  | 429656 |  |  |  |  |  |  | -2640
 |  |  |  |  |  |  |  |  |  | 429656 |  |  |  |  |  |  | 2690
 |  |  |  |  |  |  |  |  |  | 430353 |  |  |  |  |  |  | -820.3
 |  |  |  |  |  |  |  |  |  | 430353 |  |  |  |  |  |  | 870.3
 |  |  |  |  |  |  |  |  |  | 431837 |  |  |  |  |  |  | -6569.81
 |  |  |  |  |  |  |  |  |  | 431837 |  |  |  |  |  |  | 6569.81 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 432641 |  |  |  |  |  |  | -14087.57
 |  |  |  |  |  |  |  |  |  | 432641 |  |  |  |  |  |  | 14737.57 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 435778 |  |  |  |  |  |  | -2325
 |  |  |  |  |  |  |  |  |  | 435778 |  |  |  |  |  |  | 2975
 |  |  |  |  |  |  |  |  |  | 442478 |  |  |  |  |  |  | 16578.34 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 449516 |  |  |  |  |  |  | -300
 |  |  |  |  |  |  |  |  |  | 449516 |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  |  | 450898 |  |  |  |  |  |  | -26313.72
 |  |  |  |  |  |  |  |  |  | 450898 |  |  |  |  |  |  | 46628.31 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 452453 |  |  |  |  |  |  | -14541.63
 |  |  |  |  |  |  |  |  |  | 452453 |  |  |  |  |  |  | 16191.63 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 454313 |  |  |  |  |  |  | -6467
 |  |  |  |  |  |  |  |  |  | 454313 |  |  |  |  |  |  | 6517 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 457904 |  |  |  |  |  |  | -7965.65
 |  |  |  |  |  |  |  |  |  | 457904 |  |  |  |  |  |  | 8115.65 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 464303 |  |  |  |  |  |  | -39450
 |  |  |  |  |  |  |  |  |  | 464303 |  |  |  |  |  |  | 39500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 467239 |  |  |  |  |  |  | -442
 |  |  |  |  |  |  |  |  |  | 467239 |  |  |  |  |  |  | 542
 |  |  |  |  |  |  |  |  |  | 535677 |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  | 471632 |  |  |  |  |  |  | 350
 |  |  |  |  |  |  |  |  |  | 473180 |  |  |  |  |  |  | -395
 |  |  |  |  |  |  |  |  |  | 473180 |  |  |  |  |  |  | 445
 |  |  |  |  |  |  |  |  |  | 478940 |  |  |  |  |  |  | -6250
 |  |  |  |  |  |  |  |  |  | 478940 |  |  |  |  |  |  | 6900 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 480807 |  |  |  |  |  |  | -21874.64
 |  |  |  |  |  |  |  |  |  | 480807 |  |  |  |  |  |  | 110555.31 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 485345 |  |  |  |  |  |  | -25205
 |  |  |  |  |  |  |  |  |  | 485345 |  |  |  |  |  |  | 25205 |  | Closed
 |  |  |  |  |  |  |  |  |  | 489783 |  |  |  |  |  |  | -30500
 |  |  |  |  |  |  |  |  |  | 489783 |  |  |  |  |  |  | 30500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 495236 |  |  |  |  |  |  | -3910
 |  |  |  |  |  |  |  |  |  | 495236 |  |  |  |  |  |  | 6933 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 496197 |  |  |  |  |  |  | -550
 |  |  |  |  |  |  |  |  |  | 496197 |  |  |  |  |  |  | 650
 |  |  |  |  |  |  |  |  |  | 508616 |  |  |  |  |  |  | -1043
 |  |  |  |  |  |  |  |  |  | 508616 |  |  |  |  |  |  | 1043
 |  |  |  |  |  |  |  |  |  | 502718 |  |  |  |  |  |  | -377
 |  |  |  |  |  |  |  |  |  | 502718 |  |  |  |  |  |  | 577
 |  |  |  |  |  |  |  |  |  | 504986 |  |  |  |  |  |  | -17592.62
 |  |  |  |  |  |  |  |  |  | 504986 |  |  |  |  |  |  | 20192.62 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 508596 |  |  |  |  |  |  | -400
 |  |  |  |  |  |  |  |  |  | 508596 |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  |  | 508743 |  |  |  |  |  |  | -860
 |  |  |  |  |  |  |  |  |  | 508743 |  |  |  |  |  |  | 860
 |  |  |  |  |  |  |  |  |  | 513832 |  |  |  |  |  |  | -3440
 |  |  |  |  |  |  |  |  |  | 513832 |  |  |  |  |  |  | 3500
 |  |  |  |  |  |  |  |  |  | 513863 |  |  |  |  |  |  | -6670
 |  |  |  |  |  |  |  |  |  | 513863 |  |  |  |  |  |  | 6800 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 513866 |  |  |  |  |  |  | -2440
 |  |  |  |  |  |  |  |  |  | 513866 |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  | 513892 |  |  |  |  |  |  | -2500
 |  |  |  |  |  |  |  |  |  | 513892 |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  | 516626 |  |  |  |  |  |  | -11215
 |  |  |  |  |  |  |  |  |  | 516626 |  |  |  |  |  |  | 13915 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 516775 |  |  |  |  |  |  | -3635
 |  |  |  |  |  |  |  |  |  | 516775 |  |  |  |  |  |  | 4285
 |  |  |  |  |  |  |  |  |  | 516789 |  |  |  |  |  |  | -900
 |  |  |  |  |  |  |  |  |  | 516789 |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  | 517386 |  |  |  |  |  |  | -500
 |  |  |  |  |  |  |  |  |  | 517386 |  |  |  |  |  |  | 700
 |  |  |  |  |  |  |  |  |  | 522125 |  |  |  |  |  |  | -3820
 |  |  |  |  |  |  |  |  |  | 522125 |  |  |  |  |  |  | 3820
 |  |  |  |  |  |  |  |  |  | 522766 |  |  |  |  |  |  | 34140 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 525699 |  |  |  |  |  |  | -88373
 |  |  |  |  |  |  |  |  |  | 525699 |  |  |  |  |  |  | 88423 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 531926 |  |  |  |  |  |  | -74394
 |  |  |  |  |  |  |  |  |  | 531926 |  |  |  |  |  |  | 74444 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 531927 |  |  |  |  |  |  | -1200
 |  |  |  |  |  |  |  |  |  | 531927 |  |  |  |  |  |  | 1500
 |  |  |  |  |  |  |  |  |  | 531937 |  |  |  |  |  |  | -17501
 |  |  |  |  |  |  |  |  |  | 531937 |  |  |  |  |  |  | 24501 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 532137 |  |  |  |  |  |  | -51917
 |  |  |  |  |  |  |  |  |  | 532137 |  |  |  |  |  |  | 112486 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 534192 |  |  |  |  |  |  | -27500
 |  |  |  |  |  |  |  |  |  | 534192 |  |  |  |  |  |  | 33150 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 534197 |  |  |  |  |  |  | -859
 |  |  |  |  |  |  |  |  |  | 534197 |  |  |  |  |  |  | 859
 |  |  |  |  |  |  |  |  |  | 535072 |  |  |  |  |  |  | -100
 |  |  |  |  |  |  |  |  |  | 535072 |  |  |  |  |  |  | 4700
 |  |  |  |  |  |  |  |  |  | 535580 |  |  |  |  |  |  | -5152
 |  |  |  |  |  |  |  |  |  | 535580 |  |  |  |  |  |  | 5202 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 535588 |  |  |  |  |  |  | -450
 |  |  |  |  |  |  |  |  |  | 535588 |  |  |  |  |  |  | 550
 |  |  |  |  |  |  |  |  |  | 538817 |  |  |  |  |  |  | -179020
 |  |  |  |  |  |  |  |  |  | 538817 |  |  |  |  |  |  | 185020 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 543732 |  |  |  |  |  |  | -17684
 |  |  |  |  |  |  |  |  |  | 543732 |  |  |  |  |  |  | 32339 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 543938 |  |  |  |  |  |  | -200773
 |  |  |  |  |  |  |  |  |  | 543938 |  |  |  |  |  |  | 256491 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 544751 |  |  |  |  |  |  | -55685
 |  |  |  |  |  |  |  |  |  | 544751 |  |  |  |  |  |  | 60135 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 547357 |  |  |  |  |  |  | -251357
 |  |  |  |  |  |  |  |  |  | 547357 |  |  |  |  |  |  | 355518 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 547358 |  |  |  |  |  |  | -156714
 |  |  |  |  |  |  |  |  |  | 547358 |  |  |  |  |  |  | 205105 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 548427 |  |  |  |  |  |  | -62965
 |  |  |  |  |  |  |  |  |  | 548427 |  |  |  |  |  |  | 63015 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 548757 |  |  |  |  |  |  | -185681
 |  |  |  |  |  |  |  |  |  | 548757 |  |  |  |  |  |  | 274500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 548759 |  |  |  |  |  |  | -47261
 |  |  |  |  |  |  |  |  |  | 548759 |  |  |  |  |  |  | 62750 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 548772 |  |  |  |  |  |  | -60500
 |  |  |  |  |  |  |  |  |  | 548772 |  |  |  |  |  |  | 62150 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 551352 |  |  |  |  |  |  | -19510
 |  |  |  |  |  |  |  |  |  | 551352 |  |  |  |  |  |  | 26013 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 551361 |  |  |  |  |  |  | -7477
 |  |  |  |  |  |  |  |  |  | 551361 |  |  |  |  |  |  | 10850 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 551375 |  |  |  |  |  |  | -12434
 |  |  |  |  |  |  |  |  |  | 551375 |  |  |  |  |  |  | 13634 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 551382 |  |  |  |  |  |  | -40680
 |  |  |  |  |  |  |  |  |  | 551382 |  |  |  |  |  |  | 62669 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 551391 |  |  |  |  |  |  | -47271.6
 |  |  |  |  |  |  |  |  |  | 551391 |  |  |  |  |  |  | 56371 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 552056 |  |  |  |  |  |  | -15340
 |  |  |  |  |  |  |  |  |  | 552056 |  |  |  |  |  |  | 15990 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 553199 |  |  |  |  |  |  | -128642
 |  |  |  |  |  |  |  |  |  | 553199 |  |  |  |  |  |  | 209181 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 553208 |  |  |  |  |  |  | -2000
 |  |  |  |  |  |  |  |  |  | 553208 |  |  |  |  |  |  | 54680 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 554419 |  |  |  |  |  |  | -14877
 |  |  |  |  |  |  |  |  |  | 554419 |  |  |  |  |  |  | 18250 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 554421 |  |  |  |  |  |  | -3620
 |  |  |  |  |  |  |  |  |  | 554421 |  |  |  |  |  |  | 4270
 |  |  |  |  |  |  |  |  |  | 555391 |  |  |  |  |  |  | -72899
 |  |  |  |  |  |  |  |  |  | 555391 |  |  |  |  |  |  | 72949 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 558132 |  |  |  |  |  |  | -39114
 |  |  |  |  |  |  |  |  |  | 558132 |  |  |  |  |  |  | 43014 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 558135 |  |  |  |  |  |  | -45988
 |  |  |  |  |  |  |  |  |  | 558135 |  |  |  |  |  |  | 46588 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 558235 |  |  |  |  |  |  | -24100
 |  |  |  |  |  |  |  |  |  | 558235 |  |  |  |  |  |  | 27200 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 558918 |  |  |  |  |  |  | -43394
 |  |  |  |  |  |  |  |  |  | 558918 |  |  |  |  |  |  | 82500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 558969 |  |  |  |  |  |  | -3000
 |  |  |  |  |  |  |  |  |  | 558969 |  |  |  |  |  |  | 46550 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 559663 |  |  |  |  |  |  | -19104
 |  |  |  |  |  |  |  |  |  | 559663 |  |  |  |  |  |  | 25472 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 559667 |  |  |  |  |  |  | -4000
 |  |  |  |  |  |  |  |  |  | 559667 |  |  |  |  |  |  | 8252 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 560005 |  |  |  |  |  |  | -34981
 |  |  |  |  |  |  |  |  |  | 560005 |  |  |  |  |  |  | 58700 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 562671 |  |  |  |  |  |  | -47850
 |  |  |  |  |  |  |  |  |  | 562671 |  |  |  |  |  |  | 50450 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 563964 |  |  |  |  |  |  | 7963 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 563969 |  |  |  |  |  |  | 47950 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 563973 |  |  |  |  |  |  | 43750 |  | Closed
 |  |  |  |  |  |  |  |  |  | 571920 |  |  |  |  |  |  | 19745 |  | Closed
 |  |  |  |  |  |  |  |  |  | 564051 |  |  |  |  |  |  | 16014.5 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 564049 |  |  |  |  |  |  | 14362.65 |  | Closed
 |  |  |  |  |  |  |  |  |  | 563972 |  |  |  |  |  |  | 3000
 |  |  |  |  |  |  |  |  |  | 563958 |  |  |  |  |  |  | 19020 |  | Closed
 |  |  |  |  |  |  |  |  |  | 570668 |  |  |  |  |  |  | 31826.55 |  | Closed
 |  |  |  |  |  |  |  |  |  | 563960 |  |  |  |  |  |  | 18700 |  | Closed
 |  |  |  |  |  |  |  |  |  | 563966 |  |  |  |  |  |  | 12509.5 |  | Closed
 |  |  |  |  |  |  |  |  |  | 564059 |  |  |  |  |  |  | 9090.2 |  | Closed
 |  |  |  |  |  |  |  |  |  | 563968 |  |  |  |  |  |  | 3000
 |  |  |  |  |  |  |  |  |  | 563977 |  |  |  |  |  |  | 3000
 |  |  |  |  |  |  |  |  |  | 564055 |  |  |  |  |  |  | 26362.64 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 564043 |  |  |  |  |  |  | 3400
 |  |  |  |  |  |  |  |  |  | 564907 |  |  |  |  |  |  | -9063
 |  |  |  |  |  |  |  |  |  | 564907 |  |  |  |  |  |  | 39500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 564970 |  |  |  |  |  |  | -12691
 |  |  |  |  |  |  |  |  |  | 564970 |  |  |  |  |  |  | 18325 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 565335 |  |  |  |  |  |  | -14950
 |  |  |  |  |  |  |  |  |  | 565335 |  |  |  |  |  |  | 24850 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 565339 |  |  |  |  |  |  | -63627
 |  |  |  |  |  |  |  |  |  | 565339 |  |  |  |  |  |  | 85500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 565340 |  |  |  |  |  |  | -56878
 |  |  |  |  |  |  |  |  |  | 565340 |  |  |  |  |  |  | 74250 |  | In Progress
 |  |  |  |  |  |  |  |  |  | 565344 |  |  |  |  |  |  | -12651
 |  |  |  |  |  |  |  |  |  | 565344 |  |  |  |  |  |  | 12701 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 566013 |  |  |  |  |  |  | -2000
 |  |  |  |  |  |  |  |  |  | 566013 |  |  |  |  |  |  | 47044 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 566958 |  |  |  |  |  |  | -128448.53
 |  |  |  |  |  |  |  |  |  | 566958 |  |  |  |  |  |  | 142748.53 |  | In Progress