Spreadsheet: 214691d1361053203-i-need-to-find-last-column-thet-contains-data-and-first-column-that-has-data-test
Sheet: InvoiceData

SERIAL | EQUIP ID | METER TYPE |  | 2012-03-22 | 2012-06-15 | 2012-06-22 | 2012-06-25 | 2012-06-27 | 2012-06-28 | 2012-09-22 | 2012-12-22 | 2012-12-25
1 | [NAME] | BLACK |  | 4112 |  | 8224 |  |  |  | 4112 | 5112
2 | X1421 | BLACK |  | 1085 |  | 2170 |  |  |  | 1085 | 1185
3 | X1479 | BLACK |  | 12025 | 25750 |  |  |  |  | 12875 | 13875
4 | X1171 | BLACK |  | 30648 |  | 63216 |  |  |  | 31608 | 31792
5 | X1004 | BLACK |  | 39236 |  | 79748 |  |  |  | 39874 | 41494
6 | X1250 | BLACK |  | 21500 |  | 43000 |  |  |  | 21500 | 21500
7 | X1235 | BLACK |  | 24659 |  | 51296 |  |  |  | 25834 | 25902
8 | X1459 | BLACK |  | 7491 |  | 15398 |  |  |  | 7699 | 8127
9 | X1174 | BLACK |  | 17558 |  | 35766 |  |  |  | 18337 | 18733
10 | X1156 | BLACK |  | 33447 |  | 66894 |  |  |  | 33447 | 34447
11 | [NAME] | BLACK |  | 17203 |  | 37022 |  |  |  | 19291 | 20809
12 | [NAME] | BLACK |  | 29758 |  | 59516 |  |  |  | 30530 | 31530
13 | X1169 | BLACK |  | 18173 |  | 37200 |  |  |  | 18600 | 19600
14 | X1353 | BLACK |  | 16190 |  | 32380 |  |  |  | 16190 | 17083
15 | X1416 | BLACK |  | 12969 |  | 27388 |  |  |  | 13821 | 15143
16 | X1388 | BLACK |  | 15138 |  | 31962 |  |  |  | 16674 | 17674
17 | X1349 | BLACK |  | 27868 |  | 58818 |  |  |  | 29409 | 32090
18 | [NAME] | BLACK |  | 12636 |  | 26738 |  |  |  | 13369 | 13871
19 | X1173 | BLACK |  | 21916 |  | 45420 |  |  |  | 22919 | 23406
20 | X1071 | BLACK |  | 24511 |  | 49476 |  |  |  | 24738 | 25210
21 | X1168 | BLACK |  | 10339 |  | 20944 |  |  |  | 10580 | 10891
22 | X1217 | BLACK |  | 30493 |  | 62700 |  |  |  | 31350 | 33244
23 | X1460 | BLACK |  | 25503 |  | 52328 |  |  |  | 26164 | 27354
24 | X1321 | BLACK |  | 20715 |  | 43308 |  |  |  | 22431 | 23431
25 | X1237 | BLACK |  | 16809 |  | 34178 |  |  |  | 17118 | 18118
26 | [NAME] | BLACK |  | 30189 |  | 60378 |  |  |  | 30548 | 31325
27 | X1335 | BLACK |  | 15488 |  | 31930 |  |  |  | 15965 | 16965
28 | X1325 | BLACK |  | 28322 |  | 58052 |  |  |  | 29026 | 29026
29 | [NAME] | BLACK |  | 25592 |  | 55430 |  |  |  | 27771 | 28771
30 | [NAME] | BLACK |  | 17838 |  | 35808 |  |  |  | 17904 | 17988
31 | X1055 | BLACK |  | 81885 |  | 163770 |  |  |  | 81885 | 89885
32 | X1057 | BLACK |  | 84443 |  | 168890 |  |  |  | 84445 | 85445
33 | X1053 | BLACK |  | 95808 |  | 192150 |  |  |  | 96128 | 96628
34 | X1154 | BLACK |  | 81649 |  | 163298 |  |  |  | 81649 | 82649
35 | X1161 | BLACK |  | 40146 |  | 80292 |  |  |  | 40146 | 41146
36 | X1059 | BLACK |  | 51691 |  | 103382 |  |  |  | 51691 | 52691
37 | X1013 | BLACK |  | 23350 |  | 48358 |  |  |  | 24319 | 25319
38 | X1195 | BLACK |  | 26134 |  | 53214 |  |  |  | 26607
39 | X1287 | BLACK |  | 23137 |  | 46274 |  |  |  | 23137 | 24137
40 | X1048 | BLACK |  | 21124 |  | 42248 |  |  |  | 21124 | 23124
41 | X1265 | BLACK |  | 32924 |  | 67368 |  |  |  | 34515 | 35276
42 | X1021 | BLACK |  | 28920 |  | 59252 |  |  |  | 29626 | 30626
43 | X1252 | BLACK |  | 17895 |  | 35790 |  |  |  | 17895 | 18895
44 | X1045 | BLACK |  | 28726 |  | 58404 |  |  |  | 29202 | 30202
45 | [NAME] | BLACK |  | 13700 |  | 27400 |  |  |  | 13700 | 16148
46 | X1160 | BLACK |  | 25101 |  | 50404 |  |  |  | 25202 | 26202
47 | X1060 | BLACK |  | 39588 |  | 79290 |  |  |  | 39675 | 40675
48 | X1067 | BLACK |  | 32573 |  | 65848 |  |  |  | 32924 | 33924
49 | X1111 | BLACK |  | 13528 |  | 28210 |  |  |  | 14105 | 15105
50 | X1425 | BLACK |  | 18214 |  | 36428 |  |  |  | 18214 | 19214
51 | X1370 | BLACK |  | 26899 |  | 56886 |  |  |  | 28907 | 29907
52 | X1167 | BLACK |  | 40972 |  | 85112 |  |  |  | 43006 |  | 44006
53 | X1159 | BLACK |  | 4645 |  | 9290 |  |  |  | 4645 | 5645
54 | [NAME] | BLACK |  | 20767 |  | 41814 |  |  |  | 20907
55 | X1054 | BLACK |  | 29992 |  | 59984 |  |  |  | 29992 | 30992
56 | X1039 | BLACK |  | 36509 |  | 75666 |  |  |  | 37833 | 38833
57 | X1271 | BLACK |  | 7095 |  | 14190 |  |  |  | 7095 | 7560
58 | X1064 | BLACK |  | 27375 |  | 54750 |  |  |  | 27375 | 28375
59 | X1258 | BLACK |  | 38714 |  | 77626 |  |  |  | 38813 | 39813
60 | X1027 | BLACK |  | 14877 |  | 29754 |  |  |  | 14877 | 15877
61 | X1253 | BLACK |  | 34140 |  | 69644 |  |  |  | 34822 | 36144
62 | X1100 | BLACK |  | 6070 |  | 13850 |  |  |  | 6931
63 | X1142 | BLACK |  | 15524 |  | 31048 |  |  |  | 15524
64 | X1023 | BLACK |  | 33262 |  | 66524 |  |  |  | 33262 | 34262
65 | X1047 | BLACK |  | 17386 |  | 35514 |  |  |  | 17928 | 18928
66 | X1094 | BLACK |  | 25835 |  | 51670 |  |  |  | 25835
67 | X1155 | BLACK |  | 55245 |  | 111652 |  |  |  | 55826 | 56826
68 | X1489 | BLACK |  | 39961 |  | 80726 |  |  |  | 40363 | 41376
69 | X1368 | BLACK |  | 15552 |  | 31104 |  |  |  | 15552 | 16552
70 | X1041 | BLACK |  | 23362 |  | 46724 |  |  |  | 23362 | 24362
71 | X1072 | BLACK |  | 21242 |  | 43176 |  |  |  | 21588 | 22438
72 | X1194 | BLACK |  | 47821 |  | 95868 |  |  |  | 47934
73 | X1022 | BLACK |  | 27982 |  | 59004 |  |  |  | 29502 | 30502
74 | X1058 | BLACK |  | 24930 |  | 49860 |  |  |  | 24930 | 25930
75 | X1042 | BLACK |  | 31400 |  | 63030 |  |  |  | 31515 | 32515
76 | X1301 | BLACK |  | 22406 |  | 45586 |  |  |  | 23198 | 23971
77 | [NAME] | BLACK |  | 48808 |  | 97616 |  |  |  | 48808 | 50709
78 | [NAME] | BLACK |  | 41118 |  | 83620 |  |  |  | 41810 | 42810
79 | X1141 | BLACK |  | 33914 |  | 67828 |  |  |  | 33914
80 | X1311 | BLACK |  | 20338 |  | 47826 |  |  |  | 23913 | 28145
81 | X1492 | BLACK |  | 40017 |  | 80890 |  |  |  | 40445 | 41445
82 | X1166 | BLACK |  | 15937 |  | 31874 |  |  |  | 15937 | 16937
83 | X1381 | BLACK |  | 198130 |  | 396260 |  |  |  | 198130 | 199130
84 | X1340 | BLACK |  | 101990 |  | 221892 |  |  |  | 110946 | 111946
85 | X1207 | BLACK |  | 147658 |  | 295316 |  |  |  | 147658 | 148658
86 | X1247 | BLACK |  | 135452 |  | 271816 |  |  |  | 135908 | 136908
87 | X1350 | BLACK |  | 247228 |  | 499320 |  |  |  | 250808 | 250808
88 | X1339 | BLACK |  | 212015 |  | 424030 |  |  |  | 212015 | 222602
89 | X1002 | BLACK |  | 43078 |  | 87628 |  |  |  | 43892 | 43992
90 | X1206 | BLACK |  | 130338 |  | 267928 |  |  |  | 133964 | 148454
91 | X1331 | BLACK |  | 125528 |  | 251056 |  |  |  | 125528 | 126537
92 | X1244 | BLACK |  | 251858 |  | 507966 |  |  |  | 253983 | 254983
93 | X1208 | BLACK |  | 18509 |  | 41544 |  |  |  | 20772 | 22834
94 | [NAME] | BLACK |  | 51490 |  | 102980 |  |  |  | 52289 | 53289
95 | [NAME] | BLACK |  | 58491 |  | 119076 |  |  |  | 59538 | 60737
96 | X1406 | BLACK |  | 30958 |  | 61916 |  |  |  | 30958 | 31958
97 | X1497 | BLACK |  |  |  |  |  |  |  | 1 | 1001
98 | X1307 | BLACK |  | 10127 |  | 20254 |  |  |  | 10127 | 11127
99 | [NAME] | BLACK |  | 991 |  | 1982 |  |  |  | 991 | 1091
100 | X1219 | BLACK |  | 34180 |  | 68360 |  |  |  | 34180 | 35180
101 | X1366 | BLACK |  | 6942 |  | 13884 |  |  |  | 6942 | 6942
101 | X1366 | COLOR |  | 10260 |  | 20520 |  |  |  | 10260 | 10260
102 | X1212 | BLACK |  | 2614 |  | 5228 |  |  |  | 2614 | 2630
102 | X1212 | COLOR |  | 2018 |  | 4110 |  |  |  | 2055 | 2113
103 | X1230 | BLACK |  | 2849 |  | 5914 |  |  |  | 2957 | 3957
103 | X1230 | COLOR |  | 4052 |  | 8420 |  |  |  | 4210 | 4710
104 | X1198 | BLACK |  | 2262 |  | 4524 |  |  |  | 2262 | 3262
105 | X1364 | BLACK |  | 5437 |  | 10874 |  |  |  | 5437 | 6437
105 | X1364 | COLOR |  | 7575 |  | 15150 |  |  |  | 7575 | 8075
106 | X1365 | BLACK |  | 3638 |  | 9212 |  |  |  | 4606 | 5606
106 | X1365 | COLOR |  | 2619 |  | 6364 |  |  |  | 3182 | 3682
107 | X1192 | BLACK |  | 1577 |  | 3154 |  |  |  | 1577 | 2577
107 | X1192 | COLOR |  | 2651 |  | 5302 |  |  |  | 2651 | 3151