Spreadsheet: 115534d1311104675-excel-2007-extract-multiple-matches-based-on-one-criteria-line-5-schedule-2011_help
Sheet: pump list

Pump Number | pump line # | Last 12 mos sales
MM295 | 714 | 29921
MM297 | 701 | 17430
MM296 | 701 | 8327
[NAME] | 865 | 6161
MM186 | CNCWC | 6074
MM190 | CNCWC | 5038
MM-63HV | 708 | 4602
MM208 | 806 | 4114
MM-22F | 701 | 3754
MM152 | 708 | 3635
MM-82 | 701 | 3442
MM146 | 708 | 3055
MM10550 | 708 | 3016
MM342 | 708 | 2994
MM205 | 714 | 2810
MM340 | 701 | 2665
MM-63 | 708 | 2526
MM295HV | CNCWC | 2521
MM-86C |  | 2313
MM360 | 701 | 2309
MM183 | CNCWC | 2279
MM142 | 701 | 2275
M102637 | CNCWC | 2098
MM188 | 714 | 1736
MM10555 | 771 | 1724
MM134HV |  | 1600
MM247 | CNCWC | 1573
MM212 | 714 | 1471
MM-22FHV | 701 | 1453
MM211 | 795 | 1305
MM-42 | 771 | 1180
MM10833 | 714 | 1144
MM341 | 701 | 1007
[NAME] | 714 | 984
MM10553 | 717 | 943
MM10552 | 771 | 856
MM-53 | 771 | 841
MM295HP | CNCWC | 805
MM227 | 714 | 787
MM10778C | 714 | 762
MM10555C | 717 | 738
MM182 | 837 | 731
MM-90 | 708 | 727
MM-19 | 717 | 714
MM10770 | 717 | 701
MM-79HVLS-HMT | 838 | 700
MM145 | 708 | 696
MM165 | 701 | 686
MM10688 | 701 | 671
MM-62HV | 714 | 661
MM251 | 806 | 613
MM-86E | 717 | 602
MM-58F | 701 | 572
MM365 | 714 | 539
MM122 |  | 539
MM-73 | 717 | 502
MM295SLP | 714 | 500
MM10552C | 837 | 498
MM-63HP | 708 | 495
MM10778 | 717 | 494
MM10227 | CNCWC | 466
MM191 | 771 | 462
MM252 | CNCWC | 434
MM10687 | 701 | 433
MM189 | 701 | 417
MM10551 | CNCWC | 398
MM-37 | 771 | 396
MM216 | CNCWC | 372
MM355 | 714 | 363
[NAME] | 771 | 338
MM-86CHV |  | 322
MM-46 | 837 | 320
MM-71 | 771 | 302
[NAME] | 771 | 287
MM316 | 701 | 279
[NAME] | 771 | 252
[NAME] | 771 | 244
MM-67E | 771 | 225
MM-79AHV | 838 | 220
MM-79HV | 838 | 218
MM10832 |  | 212
MM317 | CNCWC | 211
M2381 | 806 | 200
MM250 |  | 199
MM22120 | CNCWC | 198
MM148 | CNCWC | 195
MM132 | 795 | 189
MM-67B | 771 | 188
MM-91 | 708 | 173
MM-15 | CNCWC | 166
MM-28FS | 837 | 158
[NAME] | 701 | 157
MM10551C | 717 | 150
MM10340 | CNCWC | 147
[NAME] | CNCWC | 146
MM111 | 708 | 132
MM-44 | 771 | 129
MM-27E | 771 | 129
MM10554 | 714 | 127
MM10355 | CNCWC | 126
MM103 | 771 | 125
MM-57HP | 708 | 121
MM-53A | 771 | 121
MM10342 | CNCWC | 115
MM-43 | 771 | 102
MM-28E | 837 | 101
MM10550C | 717 | 100
[NAME] | 865 | 98
MM181 |  | 90
MM139 | 714 | 87
MM-89 |  | 81
MM-90A |  | 74
MM-71C | 837 | 71
MM130 | 795 | 67
[NAME] |  | 66
M73277-93 |  | 61
MM10774 | 717 | 59
MM10990 | 837 | 57
M73159-12 | CNCWC | 57
MM-63L | 708 | 56
MM10176 | CNCWC | 54
MM10070-800SS | CNCWC | 51
MM-90N | 708 | 50
MM-67 | 771 | 50
MM-79D |  | 48
MM-41 | 771 | 47
MM187S | 708 | 45
MM-79CHV |  | 45
MM-27B | 771 | 43
MM190HV |  | 41
MM-50 | 771 | 38
MM-28GS | CNCWC | 37
MM10050-825SS | CNCWC | 37
MM10775 | 837 | 35
[NAME] | 714 | 34
MM-64 |  | 33
MM10050-700CT | CNCWC | 29
MM-79BHV |  | 29
MM126 |  | 28
MM-67A | CNCWC | 27
MM-96A | 708 | 26
[NAME] | CNCWC | 26
MM177 |  | 25
MM351 | 856 | 23
MM-23A |  | 23
MM-61 |  | 23
MM-40 |  | 23
MM-51 | 771 | 20
MM10990C | 837 | 20
MM-27D | CNCWC | 20
M73277-92 |  | 20
MM-75 |  | 19
MM346 | 717 | 17
MM-37R | 771 | 15
MM-25 | 771 | 15
MM-79G |  | 14
MM-79A | 806 | 13
MM10050-750SS |  | 13
MM105 |  | 12
[NAME] |  | 11
M73159-11 |  | 10
MM254 |  | 8
MM-96F |  | 6
MM-67C |  | 6
MM-79C |  | 6
[NAME] |  | 6
MM10070-900SS |  | 5
MM350 |  | 5
MM10055-750SS |  | 4
MM-58H |  | 4
MM-27H |  | 3
MM10055-825SS |  | 2
MM10077-900SS | CNCWC | 1
MM10077-800SS | CNCWC | 1
MM10055-700CT |  | 1
1805398C93 | 771 | 0
M12603243 |  | 0
MM193 |  | -6