Spreadsheet: 133893d1324777564-finding-max-value-if-excel-sample
Sheet: Sheet1

OrderID | TypeID | VolEnt | VolRem | Price | MinVol | Bid | Duration | StationID | Range | [NAME]
2385213747 | 16678 | 1482000 | 1482000 | 358 | 1 | 0 | 1 | 60003760 | 32767 | 0
2384796444 | 16678 | 1025896 | 1025896 | 247.47 | 1 | 0 | 30 | 60003760 | 32767 | 0
2384989363 | 16678 | 1045698 | 1045698 | 247.4 | 1 | 0 | 30 | 60003760 | 32767 | 0
2385223453 | 16678 | 5219 | 5219 | 247.36 | 1 | 0 | 90 | 60003760 | 32767 | 0
2385271961 | 16678 | 672000 | 307882 | 247.08 | 1 | 0 | 1 | 60003760 | 32767 | 0
2334307770 | 16678 | 17994632 | 17994632 | 247.07 | 1 | 0 | 90 | 60003760 | 32767 | 0
2385493926 | 16678 | 1056987 | 1056987 | 247.05 | 1 | 0 | 30 | 60003760 | 32767 | 0
2385536316 | 16678 | 7000000 | 6600000 | 246.99 | 1 | 0 | 90 | 60003760 | 32767 | 0
2385562312 | 16678 | 1171295 | 1171295 | 246.97 | 1 | 0 | 30 | 60003760 | 32767 | 0
2385226295 | 16678 | 7933457 | 4229666 | 244 | 1 | 0 | 90 | 60003760 | 32767 | 0
2385737068 | 16678 | 3744000 | 3744000 | 243.98 | 1 | 0 | 7 | 60003760 | 32767 | 0
2384977138 | 16678 | 800428 | 794028 | 243.96 | 1 | 0 | 90 | 60003760 | 32767 | 0
2385770950 | 16678 | 3744857 | 3616417 | 243.92 | 1 | 0 | 90 | 60003760 | 32767 | 0
2384668118 | 16678 | 10732834 | 3134058 | 243.91 | 1 | 0 | 90 | 60003760 | 32767 | 0
2385589447 | 16678 | 300000 | 299999 | 211 | 1 | 1 | 90 | 60003760 | 0 | 0
2385348718 | 16678 | 10000000 | 6255143 | 210.89 | 1 | 1 | 90 | 60003760 | -1 | 0
2384874648 | 16678 | 14256000 | 2952878 | 210.88 | 1 | 1 | 90 | 60003760 | -1 | 0
2385773826 | 16678 | 1200000 | 1200000 | 210.84 | 1 | 1 | 90 | 60003760 | -1 | 0
2385774092 | 16678 | 100000 | 100000 | 210.84 | 1 | 1 | 3 | 60003760 | -1 | 0
2385759801 | 16678 | 100000 | 100000 | 210.81 | 1 | 1 | 90 | 60003760 | -1 | 0
2385354100 | 16678 | 6000000 | 3984000 | 210.79 | 1 | 1 | 90 | 60003760 | -1 | 0
2385686027 | 16678 | 1000000 | 412000 | 210.78 | 1 | 1 | 90 | 60003760 | -1 | 0
2385674490 | 16678 | 381600 | 381600 | 210.77 | 1 | 1 | 90 | 60003760 | -1 | 0
2385672608 | 16678 | 2968000 | 2968000 | 210.76 | 1 | 1 | 90 | 60003760 | 0 | 0
2385407315 | 16678 | 300000 | 300000 | 210.73 | 1 | 1 | 90 | 60003760 | -1 | 0
2384795330 | 16678 | 1000000 | 796417 | 210.72 | 1 | 1 | 1 | 60003760 | -1 | 0
2384753252 | 16678 | 1000000 | 1000000 | 210.71 | 1 | 1 | 1 | 60003760 | -1 | 0
2385554374 | 16678 | 700000 | 700000 | 210.58 | 1 | 1 | 90 | 60001546 | 3 | 0
2385406539 | 16678 | 1209360 | 1209360 | 210.54 | 1 | 1 | 14 | 60003760 | -1 | 0
2385405277 | 16678 | 100 | 100 | 210.52 | 1 | 1 | 90 | 60003760 | -1 | 0
2385459352 | 16678 | 500000 | 500000 | 210.48 | 1 | 1 | 90 | 60003760 | -1 | 0
2374414049 | 16678 | 200000 | 200000 | 210.4 | 1 | 1 | 90 | 60003760 | -1 | 0
2385243914 | 16678 | 5000000 | 4674221 | 210.32 | 1 | 1 | 90 | 60003760 | -1 | 0
2382111558 | 16678 | 3000000 | 2999950 | 210.31 | 1 | 1 | 14 | 60003760 | -1 | 0
2384830352 | 16678 | 598500 | 598500 | 210.29 | 1 | 1 | 90 | 60003760 | -1 | 0
2384832318 | 16678 | 2000000 | 1266104 | 210.23 | 1 | 1 | 14 | 60003760 | -1 | 0
2334217153 | 16678 | 20000000 | 19716089 | 210.19 | 1 | 1 | 90 | 60003760 | -1 | 0
2384746168 | 16678 | 130000 | 130000 | 209.98 | 1 | 1 | 90 | 60003760 | -1 | 0
2384591246 | 16678 | 100000 | 100000 | 209.89 | 1 | 1 | 14 | 60003760 | -1 | 0
2383806555 | 16678 | 125000 | 125000 | 209.82 | 1 | 1 | 30 | 60003760 | -1 | 0
2375118820 | 16678 | 5000000 | 1247559 | 209.8 | 1 | 1 | 90 | 60003760 | -1 | 0
2384329592 | 16678 | 1680000 | 1680000 | 209.67 | 1 | 1 | 90 | 60003760 | -1 | 0
2384363561 | 16678 | 173250 | 173250 | 209.65 | 1 | 1 | 7 | 60002806 | -1 | 0
2383842878 | 16678 | 10000000 | 7612000 | 209.22 | 1 | 1 | 90 | 60003760 | -1 | 0
2376825295 | 16678 | 1000000 | 1000000 | 207.57 | 1 | 1 | 90 | 60003760 | -1 | 0
2376784934 | 16678 | 50000 | 50000 | 207.5 | 1 | 1 | 90 | 60003760 | -1 | 0
2376587470 | 16678 | 500000 | 500000 | 207 | 1 | 1 | 90 | 60003760 | -1 | 0
2376483611 | 16678 | 10000 | 10000 | 206.05 | 1 | 1 | 90 | 60001807 | 2 | 0
2376417285 | 16678 | 75000 | 75000 | 206.02 | 1 | 1 | 90 | 60003760 | -1 | 0
2373797730 | 16678 | 10000000 | 10000000 | 202.2 | 1 | 1 | 30 | 60003760 | -1 | 0
2364871024 | 16678 | 5000000 | 2555801 | 200.27 | 1 | 1 | 90 | 60003760 | -1 | 0
2371384877 | 16678 | 1000000 | 1000000 | 200.26 | 1 | 1 | 90 | 60003760 | -1 | 0
2370502828 | 16678 | 490000 | 490000 | 199.93 | 1 | 1 | 90 | 60003760 | -1 | 0
2375593515 | 16678 | 5000000 | 5000000 | 199 | 1 | 1 | 90 | 60003760 | -1 | 0
2371386818 | 16678 | 2000000 | 2000000 | 194.09 | 1 | 1 | 90 | 60003760 | -1 | 0
2369835602 | 16678 | 400000 | 400000 | 191 | 1 | 1 | 90 | 60003760 | -1 | 0
2372015113 | 16678 | 50000 | 50000 | 190.2 | 1 | 1 | 90 | 60003760 | -1 | 0
2360690434 | 16678 | 10000 | 10000 | 190.05 | 1 | 1 | 90 | 60003760 | -1 | 0
2381209905 | 16678 | 5300000 | 5300000 | 190.02 | 1 | 1 | 7 | 60003760 | -1 | 0
2329519318 | 16678 | 375878 | 375878 | 190.01 | 1 | 1 | 90 | 60003760 | -1 | 0
2290634750 | 16678 | 10000000 | 10000000 | 182.41 | 1 | 1 | 90 | 60003760 | -1 | 0
2384933281 | 16678 | 10000000 | 10000000 | 181.13 | 100000 | 1 | 90 | 60002281 | 32767 | 0
2362980712 | 16678 | 2261142 | 2261142 | 180 | 1 | 1 | 90 | 60003760 | -1 | 0
2362980962 | 16678 | 2261142 | 2261142 | 180 | 1 | 1 | 90 | 60003760 | -1 | 0
2310919629 | 16678 | 500000 | 500000 | 180 | 1 | 1 | 90 | 60003760 | 0 | 0
2370275008 | 16678 | 400000 | 375333 | 162.16 | 1 | 1 | 90 | 60003760 | 40 | 0
2246461295 | 16678 | 10000000 | 10000000 | 162.15 | 1 | 1 | 90 | 60003760 | -1 | 0
2362449021 | 16678 | 1000000 | 967645 | 155.01 | 1 | 1 | 90 | 60003760 | 40 | 0
2351356429 | 16678 | 1000000 | 995801 | 154.99 | 1 | 1 | 90 | 60006880 | 20 | 0
2356723495 | 16678 | 500000 | 500000 | 150 | 1 | 1 | 90 | 60003760 | -1 | 0
2336850459 | 16678 | 5000000 | 5000000 | 26 | 1000 | 1 | 90 | 60003760 | 32767 | 0
2311854257 | 16678 | 5000000 | 5000000 | 25 | 1000 | 1 | 90 | 60003760 | 32767 | 0
2046713138 | 16678 | 100000 | 100000 | 20.05 | 1 | 1 | 90 | 60000688 | 10 | 0
2324812703 | 16678 | 10000000 | 10000000 | 0.1 | 1 | 1 | 90 | 60003760 | 32767 | 0