Spreadsheet: 60369d1260915545-autofill-above-in-empty-cells-sample
Sheet: Sheet1

ACCT # | Brand | Sales
20000300 | LIF | 13459.02
20000300 | SOS | 11168.72
20000300 | HOR | 2856.51
20000300 | SOO | 2204
20000300 | OTH | 1006.2
20000300 | DVD | 110.14
20000300 | ANC | 88.24
20000300 | CDS | 6.06
20000300 | FRT | 2.99
20000300 |  | 30901.88
20001031 | OTH | 19.95
20001031 | FRT | 8
20001031 | RAMSEY | 27.95
20001214 | LIF | 272.75
20001214 | FRT | 40.91
20001214 | SOS | 15.96
20001214 | WYLIE | 329.62
20001408 | SOS | 59.96
20001408 | ONG | 59.96
20001552 | LIF | 36.95
20001552 | FRT | 8
20001552 | ARY WAD | 44.95
20001621 | LIF | 262
20001621 | BIRD | 262
20001808 | SOS | 389.75
20001808 | LIF | 108.9
20001808 | ANC | 44.9
20001808 | HOR | 27
20001808 | REBECCA | 570.55
20001812 | LIF | 221.2
20001812 | SOS | 71.96
20001812 | FRT | 16
20001812 | MITH | 309.16
20001922 | OTH | 0
20001922 | HOLDER | 0
20002155 | LIF | 17.6
20002155 | CHIM | 17.6
20002295 | LIF | 74
20002295 | HOR | 7
20002295 | FRT | 6.47
20002295 | LLER | 87.47
20002340 | ANC | 25
20002340 | FRT | 5
20002340 | WILEY | 30
20002693 | LIF | 65.6
20002693 | ENNY | 65.6
20003063 | HOR | 41.6
20003063 | ERS | 41.6
20003537 | LIF | 212.8
20003537 | FRT | 8
20003537 | NE | 220.8
20003934 | LIF | 283.65
20003934 | OTH | 52.68
20003934 | VERMYER | 336.33
20003996 | LIF | 27.16
20003996 | TAX | 1.83
20003996 | JOHNSO | 28.99
20004107 | LIF | 295.2
20004107 | SOS | 179.88
20004107 | ANC | 10.36
20004107 | GOSSETT | 485.44
 | LIF | 82.76
 | HOR | 10
 | FRT | 8
20004222 | KRUG | 100.76
 | LIF | 131.2
20004326 | ANS | 131.2
 | LIF | 82.11
20004373 | & WILL | 82.11
 | SOS | 349.95
20004422 | WELL | 349.95
 | SOS | 179.88
 | TAX | 14.39
20004517 | E ROZEL | 194.27
 | LIF | 118.1
20004588 | T | 118.1
 | LIF | 30.31
20004658 | NGRAM | 30.31
 | LIF | 83.26
20004790 | OGUE | 83.26
 | LIF | 423.25
 | OTH | 0
20004893 | MAGLIOL | 423.25
 | LIF | 12.6
 | FRT | 5
20005105 | NELAS | 17.6
 | SOS | 279.96
 | FRT | 8
20005298 | AY | 287.96
 | LIF | 169.45
 | ANC | 36.75
20005389 | RODGERS | 206.2
 | LIF | 499.08
 | DVD | 15.96
 | OTH | 10.36
20005580 | WYATT | 525.4
 | LIF | 98.4
 | DVD | 15.96
 | FRT | 8
20005878 | AMS | 122.36
 | SOS | 527.9
 | FRT | 16
20005925 | ONGNECK | 543.9
 | LIF | 114.9
 | OTH | 19.95
20006061 | BONDS | 134.85
 | SOS | 149.9
20006188 | RABLE | 149.9
 | HOR | 21.6
 | LIF | 13.44
 | FRT | 5
20006208 | ARIE CA | 40.04
 | SOS | 0
20006405 | CHAFER | 0
 | SOS | 633.12
20007080 | LATER | 633.12
 | SOS | 59.96
 | LIF | 17.08
20007189 | HELPS | 77.04
 | LIF | 145.5
 | FRT | 13
20007353 | [NAME] | 158.5
 | LIF | 37.8
20007354 | TH GLEN | 37.8
 | LIF | 32.8
 | TAX | 1.97
20007425 | AUBNER | 34.77
 | LIF | 51.9
 | FRT | 5
20007468 | LFORD | 56.9
 | SOS | 179.88
 | FRT | 8
20007812 | USHA | 187.88
 | LIF | 34.28
 | FRT | 8
 | ANC | 4.39
20007969 | SHELLE | 46.67
 | OTH | 1.06
20007985 | NKRES | 1.06
 | LIF | 32.8
 | TAX | 2.72
20008005 | ARER | 35.52
 | SOS | 59.96
 | ANC | 10.36
20008072 | JULIE | 70.32
 | SOS | 74.95
 | LIF | 25.55
20008079 | TIS | 100.5
 | HOR | 68.76
 | ANC | 58.35
 | FRT | 8
20008304 | Z ARELL | 135.11
 | SOS | 119.92
 | TAX | 8.39
20008434 | TH BROU | 128.31
 | SOS | 26.95
 | LIF | 21
20008614 | MS | 47.95
 | SOS | 74.95
 | LIF | 56.95
 | ANC | 24.95
20008661 | KAFKA | 156.85
 | LIF | 18.15
20008701 | WHITMA | 18.15
 | LIF | 49.95
 | FRT | 8
 | SOS | 0
20008736 | & ELLE | 57.95
 | LIF | 132.48
 | DVD | 16.96
20008777 | MOLINE | 149.44
 | LIF | 656
20008974 | ZEK | 656
 | LIF | 59.7
 | ANC | 13.99
 | FRT | 5.9
20009072 | BERSOLE | 79.59
 | LIF | 88.72
 | SOS | 35
20009130 | VALLEJO | 123.72
 | LIF | 361.5
 | HOR | 109.95
 | ANC | 19.95
 | WVR | 0
20009295 | SHIELDS | 491.4
 | LIF | 139.96
 | FRT | 8
20009357 | EDWARD | 147.96
 | SOS | 71.96
 | LIF | 10.08
20009471 | ETROSKI | 82.04
 | LIF | 26.88
 | FRT | 16
20009484 | UTTER | 42.88
 | LIF | 219.81
20009510 | NDELIUS | 219.81
 | SOS | 74.95
20009587 | DOSS | 74.95
 | SOS | 119.92
 | LIF | 91.5
20009628 | ESLEY | 211.42
 | SOS | 149.9
 | FRT | 8
20009689 | UALLS | 157.9
 | LIF | 91.44
20009788 | ENSCH | 91.44
 | LIF | 164
 | OTH | 1.2
20009869 | LIAMS | 165.2
 | LIF | 123.96
 | DVD | 17.56
 | FRT | 14.31
20010015 | HECK | 155.83
 | SOS | 119.92
 | FRT | 8
20010082 | RVEY | 127.92
 | LIF | 62.36
 | HOR | 57.56
 | ANC | 30.76
 | DVD | 15.96
 | FRT | 8
20010185 | UBAKER | 174.64
 | SOS | 395.76
 | FRT | 31.66
20010218 | [NAME] | 427.42
 | LIF | 41.56
20010342 | [NAME] | 41.56
 | CDS | 43.1
 | DVD | 23.92
 | HOR | 19.96
 | ANC | 10.36
 | FRT | 7.79
20010349 | LLEN | 105.13
 | LIF | 149.9
 | DVD | 13.95
 | SOS | 8
 | FRT | 2.99
20010374 | WURTZ | 174.84
 | HOR | 90.68
 | LIF | 31.16
 | ANC | 7.2
20010582 | SCHICK | 129.04
 | SOS | 57.51
 | FRT | 8
20010691 | E VAN E | 65.51
 | LIF | 59.92
 | ANC | 11.99
20010965 | DWIN | 71.91
 | SOS | 149.9
 | LIF | 29.5
 | FRT | 17.34
20011059 | TRNAD | 196.74
 | LIF | 156.04
 | ANC | 21.11
20011103 | ENNETT | 177.15
 | OTH | 1
20011223 | /MARIAN | 1
 | POW | 16.78
20011351 | ZER | 16.78
 | OTH | 3
20011486 | ASTROW | 3
 | LIF | 104.68
20011624 | [NAME] | 104.68
 | LIF | 475.84
 | TAX | 34.81
 | ANC | 23.94
 | DVD | 15.96
20011697 | MOSES | 550.55
 | LIF | 449.9
20011841 | DAS | 449.9
 | SOS | 359.76
 | TAX | 6.74
20011893 | LINDSE | 366.5
 | LIF | 264.75
 | FRT | 21.18
20012402 | VIN | 285.93
 | LIF | 236.56
 | FRT | 16
20012461 | ANTHON | 252.56
 | HOR | 63.2
20012523 | AYLOR | 63.2
 | LIF | 7.4
 | FRT | 5
20012592 | BLADA | 12.4
 | SOS | 279.96
 | FRT | 8
20012873 | L. FONT | 287.96
 | LIF | 203.12
 | FRT | 30.26
20012979 | RAWMER | 233.38
 | SOS | 0
20013005 | RIQUEZ | 0
 | SOS | 349.95
20013307 | REELAND | 349.95
 | LIF | 101.36
 | ANC | 9.55
20013375 | A HARV | 110.91
 | LIF | 205.56
20013492 | NE BRIL | 205.56
 | LIF | 64.12
20013648 | DAY | 64.12
 | LIF | 41.56
 | TAX | 3.11
20013754 | [NAME] | 44.67
 | SOS | 555.76
 | LIF | 243.56
 | FRT | 41.55
20013881 | ARP | 840.87
 | LIF | 107.62
 | TAX | 8.43
20014049 | PARKINS | 116.05
 | LIF | 339.68
20014280 | & LILI | 339.68
 | LIF | 68.64
 | TAX | 6.04
20014348 | JORDAN | 74.68
 | LIF | 343.6
 | FRT | 16
20014402 | SUSAN B | 359.6
 | LIF | 57.9
20014530 | TOUGH | 57.9
 | LIF | 52.6
 | FRT | 16
20014576 | L STAND | 68.6
 | LIF | 354.4
 | OTH | 14.5
20014608 | SHANKS | 368.9
 | SOS | 74.95
 | FRT | 6
20014709 | [NAME] | 80.95
 | SOS | 223.84
 | LIF | 106.28
 | FRT | 26.57
20014868 | . THOMA | 356.69
 | LIF | 450
 | HOR | 109.95
20014908 | REWER | 559.95
 | DVD | 99.64
 | ANC | 55.88
 | LIF | 43.56
20014919 | ATTERFI | 199.08
 | LIF | 144.64
20014969 | T SMITH | 144.64
 | LIF | 44.16
 | FRT | 8
20015159 | WIGGINS | 52.16
 | LIF | 537.5
20015230 | RAY CAR | 537.5
 | SOS | 279.96
 | FRT | 8
20015417 | CANLAN | 287.96
 | SOS | 119.92
 | LIF | 56.4
 | FRT | 16
20015502 | SCHNEID | 192.32
 | SOS | 349.95
20015659 | PPALA | 349.95
 | SOS | 35.96
 | TAX | 1.8
20015817 | BERTS | 37.76
 | LIF | 84.87
20015830 | CGUNIGA | 84.87
 | HOR | 82.4
 | LIF | 71.12
 | FRT | 16
20015909 | [NAME] | 169.52
 | LIF | 207.8
20016029 | ATSON | 207.8
 | SOS | 8
20016032 | UGHES | 8
 | LIF | 103.9
 | SOS | 26.95
 | ANC | 12.95
20016077 | EEN | 143.8
 | LIF | 220.8
20016185 | POOLE | 220.8
 | FRT | 8
 | OTH | 4.45
 | LIF | 4.1
20016220 | GROFF | 16.55
 | LIF | 207.8
 | FRT | 8
20016453 | AVERY | 215.8
 | SOS | 35
20016515 | DNER | 35
 | LIF | 87.36
20016519 | HASE | 87.36
 | LIF | 41
 | FRT | 8
20016684 | GETER | 49
 | LIF | 260.4
 | OTH | 0
20016892 | & BARBA | 260.4
 | LIF | 42.95
 | ANC | 31.9
 | FRT | 8
20017270 | ANSELL | 82.85
 | LIF | 366
 | SOS | 279.96
 | HOR | 96.72
 | FRT | 33.47
20017476 | [NAME] | 776.15
 | SOS | 44.95
 | FRT | 5
20017482 | ITUS | 49.95
 | ANC | 57.94
 | FRT | 21
 | LIF | 16.6
20017788 | OLE | 95.54
 | LIF | 163.05
 | FRT | 56.5
 | DVD | 9.95
20017892 | ERACADE | 229.5
 | SOS | 0
20017918 | WALD | 0
 | LIF | 245.44
 | FRT | 8
20018424 | CADEMY | 253.44
 | LIF | 86.32
 | DVD | 15.96
 | FRT | 8
20018573 | LYNN BA | 110.28
 | LIF | 132.35
 | FRT | 19.85
20018631 | RRIS | 152.2
 | SOS | 839.88
 | TAX | 42.83
20018928 | HOLDMAN | 882.71
 | SOS | 63.71
 | FRT | 8
20019215 | VANDERW | 71.71
 | LIF | 359.4
20019422 | DUBOSE | 359.4
 | HOR | 10
 | TAX | 0.05
20019625 | [NAME] | 10.05
 | LIF | 68.64
20019641 | ICKSON | 68.64
 | LIF | 29.9
20019663 | DELL | 29.9
 | LIF | 190.58
 | FRT | 16
20019904 | ESLIN | 206.58
 | HOR | 25
20020009 | WHATLE | 25
 | SOS | 35.96
 | FRT | 8
20020561 | A GARDE | 43.96
 | LIF | 20.95
20020656 | OUCETTE | 20.95
 | LIF | 331.84
20020869 | IST | 331.84
 | HOR | 21.6
 | TAX | 1.3
20020976 | WITTER | 22.9
 | LIF | 69.7
 | FRT | 8
20020999 | MAHAN | 77.7
 | SOS | 19.95
20021036 | NEY | 19.95
 | LIF | 175.85
 | FRT | 14.07
20021057 | MSDEN | 189.92
 | SOS | 349.95
20021069 | SHINAVI | 349.95
 | DVD | 34.9
 | FRT | 5
20021179 | LDRIDGE | 39.9
 | SOS | 119.92
 | LIF | 32.8
 | TAX | 12.22
20021959 | TYER | 164.94
 | SOS | 0
20021997 | NS | 0
 | LIF | 45.56
 | TAX | 3.19
20022182 | LLESPIE | 48.75
 | LIF | 139.44
20022245 | NDRUS | 139.44
 | LIF | 32.98
 | TAX | 1.2
20022249 | CKANE | 34.18
 | LIF | 339.6
20022754 | ARRICK | 339.6
 | LIF | 65.6
 | SOS | 43.12
 | TAX | 8.7
20022898 | A KAY G | 117.42
 | LIF | 80.5
 | SOS | 74.95
 | FRT | 15.36
20023202 | OSS | 170.81
 | LIF | -49.9
20023322 | ACHLIN | -49.9
 | LIF | 369.6
20023591 | GRIMES | 369.6
 | HOR | 160.26
 | SOS | 119.92
20023635 | RUEMENA | 280.18
 | HOR | 25
 | FRT | 7.99
20024038 | [NAME] | 32.99
 | LIF | 36.55
 | FRT | 8
20024073 | WILLIG | 44.55
 | LIF | 32.8
 | HOR | 11.2
20024164 | IERCE | 44
 | OTH | 11.4
20024456 | RRY | 11.4
 | LIF | 243.56
 | DVD | 15.96
20024497 | IBAUDEA | 259.52
 | OTH | 0
20024582 | CHRIST | 0
 | SOS | 149.9
20024618 | YN SHOF | 149.9
 | LIF | 201.76
 | HOR | 40
20024620 | ORJANC | 241.76
 | HOR | 161.05
 | LIF | 91.12
20024715 | RA | 252.17
 | SOS | 479.68
 | HOR | 129.56
 | FRT | 32
20024798 | ALTON | 641.24
 | SOS | 298.6
 | TAX | 11.69
20024958 | SUAREZ | 310.29
 | SOS | 139.04
 | HOR | 20
20025029 | PATRIC | 159.04
 | SOS | 254.84
20025095 | PEVETO | 254.84
 | HOR | 40
 | TAX | 2.8
20025190 | BLACKF | 42.8
 | LIF | 99.12
 | FRT | 8
20025477 | & TIM P | 107.12
 | SOS | 301.52
 | TAX | 24.13
 | LIF | 0
20025616 | [NAME] | 325.65
 | LIF | 65.31
 | ANC | 16.38
20025987 | FF | 81.69
 | SOS | 509.68
 | FRT | 24
 | DVD | 12.71
20026295 | L NOVOT | 546.39
 | LIF | 211.8
 | FRT | 16.94
20026308 | OUDREAU | 228.74
 | SOS | 224.85
 | FRT | 17.99
20026328 | AY | 242.84
 | LIF | 144.68
 | FRT | 12.5
20026388 | WISEBUR | 157.18
 | OTH | 19.95
 | FRT | 5
20026395 | SMITH | 24.95
 | HOR | 55.96
 | TAX | 3.36
20026441 | RT | 59.32
 | LIF | 82.4
20026530 | OLL | 82.4
 | SOS | 751.77
 | POW | 32.68
 | FRT | 32
 | ANC | 11.89
20026647 | PAYNE | 828.34
 | SOS | 74.95
 | FRT | 6
20026874 | CHIPPER | 80.95
 | SOS | 59.96
20027128 | WEATHER | 59.96
 | HOR | 139.5
 | FRT | 16
20027334 | [NAME] | 155.5
 | SOS | 149.9
 | FRT | 8
20027450 | ESLINS | 157.9
 | LIF | 111.16
 | SOS | 59.96
20027509 | IELSEN | 171.12
 | LIF | 75.88
 | FRT | 8
20027632 | BROWN | 83.88
 | LIF | 384.38
 | HOR | 61.16
 | DVD | 16.96
20027673 | & EUNI | 462.5
 | LIF | 257.05
 | OTH | 4.4
20027842 | COLLEEN | 261.45
 | SOS | 179.88
 | LIF | 45.56
 | FRT | 16
20028038 | TOWE | 241.44
 | LIF | 21.42
 | FRT | 5
20028372 | EVELYN | 26.42
 | SOS | 539.6
20028440 | BBARD | 539.6
 | SOS | 53.9
 | FRT | 8
20028508 | BRUEGGE | 61.9
 | LIF | 348.45
20028544 | HART | 348.45
 | SOS | 588.7
20028644 | ODD | 588.7
 | LIF | 237.12
 | DVD | 23.96
 | WVR | 16
 | OTH | 10.36
20028681 | GEARHAR | 287.44
 | LIF | 82
20028988 | OHNSON | 82
 | LIF | 202
20029213 | IHRY | 202
 | LIF | 201.85
 | FRT | 33.49
 | OTH | 1.5
20029350 | OGNER | 236.84
 | LIF | 20.5
20029590 | TENNEY | 20.5
 | LIF | 45.75
 | TAX | 1.97
20029680 | EIN | 47.72
 | LIF | 41.56
 | HOR | 33.6
 | FRT | 8
20029963 | HUFF | 83.16
 | LIF | 113.16
20030019 | R GIESE | 113.16
 | ANC | 10.36
20030023 | HICKS | 10.36
 | FRT | 15.49
 | LIF | 4.2
20030104 | ILLER | 19.69
 | LIF | 149.56
 | HOR | 61.56
20030184 | PETERSO | 211.12
 | SOS | 22.91
 | FRT | 8
20030209 | OSTANOW | 30.91
 | HOR | 67.5
20030484 | N CIBOR | 67.5
 | LIF | 336
 | FRT | 12.5
20030865 | BOWER | 348.5
 | HOR | 82.41
 | FRT | 12.5
20031086 | HEWNING | 94.91
 | LIF | 332
20031193 | NE OLVE | 332
 | OTH | 19.95
 | FRT | 8
20031304 | RAUSCH | 27.95
 | SOS | 0
20031308 | CRAMER | 0
 | LIF | 82.15
 | SOS | 59.96
 | POW | 20.97
 | OTH | 9
 | FRT | 8
20031316 | L STEIN | 180.08
 | WVR | 24
 | LIF | 16.4
 | FRT | 16
 | DVD | 11.16
20031323 | OWARD | 67.56
 | LIF | 252.5
 | HOR | 79.84
20031521 | ORTON | 332.34
 | LIF | 63.75
 | FRT | 16
20031551 | ES | 79.75
 | SOS | 489.65
 | ANC | 44.85
 | OTH | 39.95
 | FRT | 29.57
20031598 | HARMON | 604.02
 | LIF | 131.88
20031753 | ACKLEMA | 131.88
 | ANC | 48.93
 | LIF | 40.32
 | DVD | 12.95
 | FRT | 8
20031807 | TES | 110.2
 | SOS | 8
20032033 | NE DEME | 8
 | LIF | 73.9
 | FRT | 5.91
20032196 | OHNSON | 79.81
 | SOS | 69.95
 | FRT | 8
20032278 | RAY | 77.95
 | LIF | 298.16
 | HOR | 31.96
 | ANC | 28.76
20032642 | LENDA M | 358.88
 | SOS | 474.83
 | LIF | 43.16
 | FRT | 16
20032761 | A FINLA | 533.99
 | SOS | 311.8
 | LIF | 155.35
 | HOR | 54
 | FRT | 29
 | OTH | 1
20032941 | TTLING | 551.15