Spreadsheet: 221194d1363404896-date-merge-formatting-repeat-values-test-file
Sheet: Sales-Comps

 | 2008-01-01 00:00:00 |  | 2008-02-01 00:00:00 |  | 2008-03-01 00:00:00 |  | 2008-04-01 00:00:00 |  | 2008-05-01 00:00:00 |  | 2008-06-01 00:00:00 |  | 2008-07-01 00:00:00 |  | 2008-08-01 00:00:00 |  | 2008-09-01 00:00:00 |  | 2008-10-01 00:00:00 |  | 2008-11-01 00:00:00 |  | 2008-12-01 00:00:00 |  | 2009-01-01 00:00:00 |  | 2009-02-01 00:00:00 |  | 2009-03-01 00:00:00 |  | 2009-04-01 00:00:00 |  | 2009-05-01 00:00:00 |  | 2009-06-01 00:00:00 |  | 2009-07-01 00:00:00 |  | 2009-08-01 00:00:00 |  | 2009-09-01 00:00:00 |  | 2009-10-01 00:00:00 |  | 2009-11-01 00:00:00 |  | 2009-12-01 00:00:00 |  | 2010-01-01 00:00:00 |  | 2010-02-01 00:00:00 |  | 2010-03-01 00:00:00 |  | 2010-04-01 00:00:00
Coutts | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints | Sales | Complaints
C1 | 5941674 | 115 | 7930057 | 203 | 6407416 | 188 | 8490882 | 176 | 6813323 | 177 | 6710206 | 156 | 8012228 | 200 | 5799301 | 182 | 6955745 | 145 | 5276711 | 129 | 5464933 | 96 | 6060476 | 132 | 7230723 | 191 | 6934392 | 174 | 4989243 | 165 | 7890853 | 191 | 7256284 | 169 | 7494901 | 195 | 7934044 | 211 | 8170325 | 238 | 4990420 | 113 | 5453738 | 167 | 7371714 | 248 | 5202264 | 228 | 4940137 | 110 | 6984764 | 148 | 7146452 | 172 | 6783373 | 132
C2 | 767612 | 13 | 1406603 | 34 | 2040880 | 55 | 1565263 | 28 | 1728453 | 50 | 1206310 | 23 | 995577 | 19 | 541580 | 15 | 623625 | 16 | 486761 | 8 | 449874 | 5 | 641265 | 15 | 882644 | 16 | 1316080 | 24 | 1535776 | 57 | 1483612 | 60 | 1839394 | 44 | 1592737 | 33 | 1125148 | 24 | 946774 | 26 | 596202 | 22 | 511905 | 10 | 656532 | 20 | 484043 | 6 | 578657 | 11 | 1697618 | 41 | 1806907 | 54 | 1924996 | 61
[NAME] | 2357024 | 27 | 2683737 | 19 | 3092921 | 32 | 2819875 | 18 | 3899539 | 19 | 3707087 | 31 | 4164635 | 6 | 5902742 | 18 | 4376548 | 21 | 3241452 | 27 | 3403745 | 45 | 3849764 | 56 | 2367560 | 15 | 2219962 | 22 | 2563753 | 18 | 3546914 | 20 | 3038291 | 16 | 3984471 | 22 | 4383436 | 34 | 4818582 | 71 | 3311574 | 28 | 3880306 | 34 | 3209296 | 32 | 3306504 | 40 | 3089962 | 35 | 3944219 | 27 | 3394863 | 21 | 3702270 | 22
C4 | 3588486 | 34 | 3544137 | 43 | 4640053 | 49 | 3687248 | 26 | 4252282 | 32 | 3559656 | 35 | 3624388 | 33 | 3852364 | 34 | 4805543 | 62 | 3358921 | 44 | 3736154 | 44 | 3692836 | 38 | 3780342 | 50 | 3338220 | 51 | 3182537 | 39 | 3318216 | 41 | 3772471 | 29 | 2982519 | 44 | 3518248 | 35 | 3101669 | 26 | 3669927 | 64 | 2814091 | 27 | 4612040 | 74 | 3692944 | 59 | 3893189 | 36 | 4465466 | 64 | 3527400 | 81 | 3829663 | 59
C5 | 2426600 | 86 | 3407221 | 99 | 3086855 | 127 | 2435676 | 58 | 4318823 | 142 | 3480486 | 129 | 2767297 | 72 | 2591399 | 103 | 2933922 | 104 | 2294475 | 93 | 2197998 | 100 | 2823054 | 100 | 3324634 | 113 | 3779738 | 112 | 3058676 | 125 | 2773386 | 132 | 4948146 | 194 | 2426493 | 161 | 3473778 | 92 | 2112835 | 110 | 2493002 | 121 | 2498644 | 109 | 3484497 | 114 | 2558823 | 118 | 2377708 | 86 | 3291945 | 127 | 3177323 | 124 | 3106866 | 86
C6 | 3367180 | 23 | 4542728 | 31 | 4791667 | 28 | 2811625 | 8 | 5184149 | 39 | 3870943 | 25 | 3943571 | 25 | 4867608 | 38 | 4991404 | 47 | 3685329 | 27 | 4025102 | 27 | 5229168 | 55 | 3750106 | 26 | 3757284 | 44 | 3732466 | 14 | 3457940 | 17 | 4640107 | 57 | 3355660 | 42 | 4117900 | 47 | 4800982 | 46 | 4910919 | 52 | 2686118 | 39 | 4631330 | 41 | 5055672 | 14 | 4222300 | 25 | 4980062 | 17 | 7800269 | 44 | 4584179 | 14
C7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3331982 | 101 | 3555595 | 95 | 5069703 | 159 | 4808497 | 174 | 5874469 | 203 | 4690890 | 189 | 4215236 | 151 | 4369468 | 111 | 4491478 | 151 | 3725116 | 146 | 3558758 | 116 | 5163261 | 122 | 3794054 | 114 | 3869332 | 97 | 5706740 | 147 | 4491635 | 133 | 6232612 | 160
C8 | 8410662 | 413 | 7729263 | 254 | 6609823 | 184 | 6198466 | 83 | 6468579 | 144 | 6343996 | 141 | 9391210 | 210 | 13093420 | 211 | 11504290 | 454 | 11302601 | 470 | 11201102 | 478 | 10144744 | 482 | 9398501 | 317 | 11629710 | 421 | 8684672 | 298 | 8037083 | 203 | 9655175 | 224 | 8142211 | 162 | 8645049 | 236 | 12545782 | 381 | 11742683 | 321 | 12397059 | 586 | 15295430 | 739 | 11315197 | 577 | 10451576 | 548 | 11219194 | 331 | 8325050 | 220 | 8685270 | 183
C9 | 10008482 | 98 | 10043912 | 81 | 10843912 | 60 | 6502539 | 57 | 10441114 | 46 | 8897592 | 45 | 9364350 | 81 | 9072833 | 60 | 12100951 | 62 | 9684845 | 104 | 9652605 | 90 | 10108176 | 77 | 10213226 | 106 | 10342848 | 98 | 8930195 | 101 | 9386928 | 73 | 9802045 | 88 | 8776230 | 69 | 9612209 | 74 | 11634606 | 82 | 10561411 | 100 | 10458374 | 111 | 13012444 | 178 | 10233326 | 103 | 10331228 | 100 | 12340671 | 169 | 9943029 | 99 | 11936787 | 112
 | 18419144 | 511 | 17773175 | 335 | 17453735 | 244 | 12701005 | 140 | 16909693 | 190 | 15241588 | 186 | 18755560 | 291 | 22166253 | 271 | 23605241 | 516 | 20987446 | 574 | 20853707 | 568 | 20252920 | 559 | 19611727 | 423 | 21972558 | 519 | 17614867 | 399 | 17424011 | 276 | 19457220 | 312 | 16918441 | 231 | 18257258 | 310 | 24180388 | 463 | 22304094 | 421 | 22855433 | 697 | 28307874 | 917 | 21548523 | 680 | 20782804 | 648 | 23559865 | 500 | 18268079 | 319 | 20622057 | 295