Spreadsheet: 122782d1317145161-formula-for-finding-last-incident-sales-ex
Sheet: SALES

DATE | SALER | SUM |  | SALER | SCOTT
2010-08-22 00:00:00 | SCOTT | 34656
2010-08-23 00:00:00 | PAUL | 34488 |  | [NAME] of SUM
2010-08-24 00:00:00 | PAULA | 34320 |  | DATE | Total
2011-03-08 00:00:00 | [NAME] | 34152 |  | 2010-08-22 00:00:00 | 34656
2010-08-26 00:00:00 | [NAME] | 33984 |  | Grand Total | 34656
2010-08-27 00:00:00 | SCOTT | 33816
2010-08-28 00:00:00 | PAUL | 33648
2010-08-29 00:00:00 | PAULA | 33480
2011-03-03 00:00:00 | [NAME] | 33312
2010-08-31 00:00:00 | [NAME] | 33144
2010-09-01 00:00:00 | SCOTT | 32976
2010-09-02 00:00:00 | PAUL | 32808
2010-09-03 00:00:00 | PAULA | 32640
2011-02-26 00:00:00 | [NAME] | 32472
2010-09-05 00:00:00 | [NAME] | 32304
2010-09-06 00:00:00 | SCOTT | 32136
2010-09-07 00:00:00 | PAUL | 31968
2010-09-08 00:00:00 | PAULA | 31800
2011-02-21 00:00:00 | [NAME] | 31632
2010-09-10 00:00:00 | [NAME] | 31464
2010-09-11 00:00:00 | SCOTT | 31296
2010-09-12 00:00:00 | PAUL | 31128
2010-09-13 00:00:00 | PAULA | 30960
2011-02-16 00:00:00 | [NAME] | 30792
2010-09-15 00:00:00 | [NAME] | 30624
2010-09-16 00:00:00 | SCOTT | 30456
2010-09-17 00:00:00 | PAUL | 30288
2010-09-18 00:00:00 | PAULA | 30120
2011-02-11 00:00:00 | [NAME] | 29952
2010-09-20 00:00:00 | [NAME] | 29784
2010-09-21 00:00:00 | SCOTT | 29616
2010-09-22 00:00:00 | PAUL | 29448
2010-09-23 00:00:00 | PAULA | 29280
2011-02-06 00:00:00 | [NAME] | 29112
2010-09-25 00:00:00 | [NAME] | 28944
2010-09-26 00:00:00 | SCOTT | 28776
2010-09-27 00:00:00 | PAUL | 28608
2010-09-28 00:00:00 | PAULA | 28440
2011-02-01 00:00:00 | [NAME] | 28272
2010-09-30 00:00:00 | [NAME] | 28104
2010-10-01 00:00:00 | SCOTT | 27936
2010-10-02 00:00:00 | PAUL | 27768
2010-10-03 00:00:00 | PAULA | 27600
2011-01-27 00:00:00 | [NAME] | 27432
2010-10-05 00:00:00 | [NAME] | 27264
2010-10-06 00:00:00 | SCOTT | 27096
2010-10-07 00:00:00 | PAUL | 26928
2010-10-08 00:00:00 | PAULA | 26760
2011-01-22 00:00:00 | [NAME] | 26592
2010-10-10 00:00:00 | [NAME] | 26424
2010-10-11 00:00:00 | SCOTT | 26256
2010-10-12 00:00:00 | PAUL | 26088
2010-10-13 00:00:00 | PAULA | 25920
2011-01-17 00:00:00 | [NAME] | 25752
2010-10-15 00:00:00 | [NAME] | 25584
2010-10-16 00:00:00 | SCOTT | 25416
2010-10-17 00:00:00 | PAUL | 25248
2010-10-18 00:00:00 | PAULA | 25080
2011-01-12 00:00:00 | [NAME] | 24912
2010-10-20 00:00:00 | [NAME] | 24744
2010-10-21 00:00:00 | SCOTT | 24576
2010-10-22 00:00:00 | PAUL | 24408
2010-10-23 00:00:00 | PAULA | 24240
2011-01-07 00:00:00 | [NAME] | 24072
2010-10-25 00:00:00 | [NAME] | 23904
2010-10-26 00:00:00 | SCOTT | 23736
2010-10-27 00:00:00 | PAUL | 23568
2010-10-28 00:00:00 | PAULA | 23400
2011-01-02 00:00:00 | [NAME] | 23232
2010-10-30 00:00:00 | [NAME] | 23064
2010-10-31 00:00:00 | SCOTT | 22896
2010-11-01 00:00:00 | PAUL | 22728
2010-11-02 00:00:00 | PAULA | 22560
2010-12-28 00:00:00 | [NAME] | 22392
2010-11-04 00:00:00 | [NAME] | 22224
2010-11-05 00:00:00 | SCOTT | 22056
2010-11-06 00:00:00 | PAUL | 21888
2010-11-07 00:00:00 | PAULA | 21720
2010-12-23 00:00:00 | [NAME] | 21552
2010-11-09 00:00:00 | [NAME] | 21384
2010-11-10 00:00:00 | SCOTT | 21216
2010-11-11 00:00:00 | PAUL | 21048
2010-11-12 00:00:00 | PAULA | 20880
2010-12-18 00:00:00 | [NAME] | 20712
2010-11-14 00:00:00 | [NAME] | 20544
2010-11-15 00:00:00 | SCOTT | 20376
2010-11-16 00:00:00 | PAUL | 20208
2010-11-17 00:00:00 | PAULA | 20040
2010-12-13 00:00:00 | [NAME] | 19872
2010-11-19 00:00:00 | [NAME] | 19704
2010-11-20 00:00:00 | SCOTT | 19536
2010-11-21 00:00:00 | PAUL | 19368
2010-11-22 00:00:00 | PAULA | 19200
2010-12-08 00:00:00 | [NAME] | 19032
2010-11-24 00:00:00 | [NAME] | 18864
2010-11-25 00:00:00 | SCOTT | 18696
2010-11-26 00:00:00 | PAUL | 18528
2010-11-27 00:00:00 | PAULA | 18360
2010-12-03 00:00:00 | [NAME] | 18192
2010-11-29 00:00:00 | [NAME] | 18024
2010-11-30 00:00:00 | SCOTT | 17856
2010-12-01 00:00:00 | PAUL | 17688
2010-12-02 00:00:00 | PAULA | 17520
2010-11-28 00:00:00 | [NAME] | 17352
2010-12-04 00:00:00 | [NAME] | 17184
2010-12-05 00:00:00 | SCOTT | 17016
2010-12-06 00:00:00 | PAUL | 16848
2010-12-07 00:00:00 | PAULA | 16680
2010-11-23 00:00:00 | [NAME] | 16512
2010-12-09 00:00:00 | [NAME] | 16344
2010-12-10 00:00:00 | SCOTT | 16176
2010-12-11 00:00:00 | PAUL | 16008
2010-12-12 00:00:00 | PAULA | 15840
2010-11-18 00:00:00 | [NAME] | 15672
2010-12-14 00:00:00 | [NAME] | 15504
2010-12-15 00:00:00 | SCOTT | 15336
2010-12-16 00:00:00 | PAUL | 15168
2010-12-17 00:00:00 | PAULA | 15000
2010-11-13 00:00:00 | [NAME] | 14832
2010-12-19 00:00:00 | [NAME] | 14664
2010-12-20 00:00:00 | SCOTT | 14496
2010-12-21 00:00:00 | PAUL | 14328
2010-12-22 00:00:00 | PAULA | 14160
2010-11-08 00:00:00 | [NAME] | 13992
2010-12-24 00:00:00 | [NAME] | 13824
2010-12-25 00:00:00 | SCOTT | 13656
2010-12-26 00:00:00 | PAUL | 13488
2010-12-27 00:00:00 | PAULA | 13320
2010-11-03 00:00:00 | [NAME] | 13152
2010-12-29 00:00:00 | [NAME] | 12984
2010-12-30 00:00:00 | SCOTT | 12816
2010-12-31 00:00:00 | PAUL | 12648
2011-01-01 00:00:00 | PAULA | 12480
2010-10-29 00:00:00 | [NAME] | 12312
2011-01-03 00:00:00 | [NAME] | 12144
2011-01-04 00:00:00 | SCOTT | 11976
2011-01-05 00:00:00 | PAUL | 11808
2011-01-06 00:00:00 | PAULA | 11640
2010-10-24 00:00:00 | [NAME] | 11472
2011-01-08 00:00:00 | [NAME] | 11304
2011-01-09 00:00:00 | SCOTT | 11136
2011-01-10 00:00:00 | PAUL | 10968
2011-01-11 00:00:00 | PAULA | 10800
2010-10-19 00:00:00 | [NAME] | 10632
2011-01-13 00:00:00 | [NAME] | 10464
2011-01-14 00:00:00 | SCOTT | 10296
2011-01-15 00:00:00 | PAUL | 10128
2011-01-16 00:00:00 | PAULA | 9960
2010-10-14 00:00:00 | [NAME] | 9792
2011-01-18 00:00:00 | [NAME] | 9624
2011-01-19 00:00:00 | SCOTT | 9456
2011-01-20 00:00:00 | PAUL | 9288
2011-01-21 00:00:00 | PAULA | 9120
2010-10-09 00:00:00 | [NAME] | 8952
2011-01-23 00:00:00 | [NAME] | 8784
2011-01-24 00:00:00 | SCOTT | 8616
2011-01-25 00:00:00 | PAUL | 8448
2011-01-26 00:00:00 | PAULA | 8280
2010-10-04 00:00:00 | [NAME] | 8112
2011-01-28 00:00:00 | [NAME] | 7944
2011-01-29 00:00:00 | SCOTT | 7776
2011-01-30 00:00:00 | PAUL | 7608
2011-01-31 00:00:00 | PAULA | 7440
2010-09-29 00:00:00 | [NAME] | 7272
2011-02-02 00:00:00 | [NAME] | 7104
2011-02-03 00:00:00 | SCOTT | 6936
2011-02-04 00:00:00 | PAUL | 6768
2011-02-05 00:00:00 | PAULA | 6600
2010-09-24 00:00:00 | [NAME] | 6432
2011-02-07 00:00:00 | [NAME] | 6264
2011-02-08 00:00:00 | SCOTT | 6096
2011-02-09 00:00:00 | PAUL | 5928
2011-02-10 00:00:00 | PAULA | 5760
2010-09-19 00:00:00 | [NAME] | 5592
2011-02-12 00:00:00 | [NAME] | 5424
2011-02-13 00:00:00 | SCOTT | 5256
2011-02-14 00:00:00 | PAUL | 5088
2011-02-15 00:00:00 | PAULA | 4920
2010-09-14 00:00:00 | [NAME] | 4752
2011-02-17 00:00:00 | [NAME] | 4584
2011-02-18 00:00:00 | SCOTT | 4416
2011-02-19 00:00:00 | PAUL | 4248
2011-02-20 00:00:00 | PAULA | 4080
2010-09-09 00:00:00 | [NAME] | 3912
2011-02-22 00:00:00 | [NAME] | 3744
2011-02-23 00:00:00 | SCOTT | 3576
2011-02-24 00:00:00 | PAUL | 3408
2011-02-25 00:00:00 | PAULA | 3240
2010-09-04 00:00:00 | [NAME] | 3072
2011-02-27 00:00:00 | [NAME] | 2904
2011-02-28 00:00:00 | SCOTT | 2736
2011-03-01 00:00:00 | PAUL | 2568
2011-03-02 00:00:00 | PAULA | 2400
2010-08-30 00:00:00 | [NAME] | 2232
2011-03-04 00:00:00 | [NAME] | 2064
2011-03-05 00:00:00 | SCOTT | 1896
2011-03-06 00:00:00 | PAUL | 1728
2011-03-07 00:00:00 | PAULA | 1560
2010-08-25 00:00:00 | [NAME] | 1392
2011-03-09 00:00:00 | [NAME] | 1224
2011-03-10 00:00:00 | SCOTT | 1056
2011-03-11 00:00:00 | PAUL | 888
2010-08-21 00:00:00 | [NAME] | 720