Spreadsheet: 681520d1591624370-formula-to-update-data-on-two-tabs-in-multiple-tables-excel-help_territory-analysis-lwt_6_8_20
Sheet: Backup Data

State | Orders
AL | 0
AL | 0
AR | 0
AR | 0
AZ | 0
AZ | 0
SC | 1
TX | 1
TX | 1
KY | 2
MI | 2
MO | 2
NC | 3
OK | 3
SC | 3
CA | 4
MD | 4
WI | 4
AR | 5
AL | 6
IL | 6
OK | 6
HI | 7
IN | 7
MA | 7
TX | 8
AR | 9
GA | 9
IL | 9
SC | 9
TN | 10
OK | 11
TN | 11
MN | 12
TX | 13
NC | 14
ND | 14
NE | 14
OH | 14
WI | 14
CA | 15
CA | 15
AR | 16
WA | 17
MD | 18
NY | 18
MO | 19
CO | 20
OH | 20
SC | 20
ND | 21
VA | 21
WI | 21
ID | 22
ID | 23
NY | 23
VA | 23
CA | 24
KY | 24
MA | 24
SD | 24
CA | 25
GA | 25
OH | 25
MD | 28
ME | 28
NY | 28
WI | 28
GA | 30
MA | 30
NY | 30
TX | 30
MN | 32
MO | 32
IA | 33
IL | 33
IN | 33
PR | 34
AR | 36
MO | 36
FL | 38
IL | 38
MA | 38
NY | 38
OK | 38
AR | 40
MA | 40
OH | 40
CA | 41
FL | 41
MA | 41
MA | 42
NJ | 42
AL | 43
WI | 43
CA | 45
VA | 45
CT | 46
HI | 46
IL | 46
TX | 46
IN | 47
WI | 47
CA | 48
OH | 50
IA | 51
MA | 51
MA | 51
MA | 52
NC | 52
TX | 52
MO | 53
IL | 54
MD | 54
OH | 54
TN | 54
WA | 54
WA | 55
NV | 56
WI | 56
TX | 57
WA | 57
AL | 58
FL | 59
AL | 60
MI | 60
MN | 60
NY | 60
TX | 60
CA | 62
PA | 62
PR | 62
WI | 62
AZ | 63
CA | 63
TN | 63
AR | 64
PA | 64
MO | 65
OK | 66
IL | 67
MI | 67
FL | 68
NJ | 68
OK | 68
TX | 68
NV | 69
CA | 70
VA | 70
CT | 71
ID | 71
MI | 71
MN | 71
MN | 71
SD | 71
CA | 72
MO | 72
NY | 72
MD | 73
NY | 73
UT | 73
ME | 74
CA | 75
CA | 75
FL | 75
IL | 75
KS | 75
MA | 75
NY | 75
PA | 75
RI | 75
SC | 75
TX | 75
AR | 76
ME | 76
MI | 76
NJ | 76
OK | 76
PA | 76
VA | 76
FL | 77
IL | 77
MI | 77
ND | 77
NJ | 77
PA | 77
PA | 77
PA | 77
SC | 77
TX | 77
WI | 77
FL | 78
LA | 78
NC | 78
NY | 78
TX | 78
VA | 78
WA | 78
AL | 79
AL | 79
CA | 79
IL | 79
IN | 79
MD | 79
NJ | 79
NJ | 79
NJ | 79
CA | 80
IN | 80
IN | 80
KS | 80
NJ | 80
OH | 80
OK | 80
TX | 80
TX | 80
MA | 81
ME | 81
MO | 81
TN | 81
TX | 81
CA | 82
NE | 82
NY | 82
PA | 82
PA | 82
SC | 82
SD | 82
CA | 83
IL | 83
IN | 83
PA | 83
SD | 83
FL | 84
IA | 84
IL | 84
MI | 84
MI | 84
MN | 84
MN | 84
NJ | 84
PA | 84
TN | 84
WA | 84
WI | 84
IL | 85
IL | 85
KS | 85
MO | 85
NJ | 85
NY | 85
PA | 85
PA | 85
TN | 85
TX | 85
VT | 85
MA | 86
NJ | 86
NY | 86
TX | 86
VA | 86
WV | 86
CA | 87
CT | 87
MI | 87
MN | 87
MN | 87
NY | 87
PA | 87
TX | 87
VA | 87
CT | 88
FL | 88
GA | 88
IL | 88
IL | 88
KY | 88
AL | 89
KS | 89
MO | 89
NH | 89
SC | 89
KY | 90
MI | 90
NY | 90
NY | 90
RI | 90
WI | 90
WI | 90
IN | 91
KY | 91
KY | 91
MA | 91
OH | 91
OR | 91
PA | 91
SC | 91
TN | 91
WI | 91
AZ | 92
CA | 92
MN | 92
TX | 92
MI | 93
PA | 93
WA | 93
AL | 94
FL | 94
NY | 94
UT | 94
KY | 95
NE | 95
VA | 95
AL | 96
FL | 96
GA | 96
IL | 96
MD | 96
NH | 96
NY | 96
ID | 97
NC | 97
NE | 97
NE | 97
UT | 97
VA | 97
NH | 98
AZ | 99
ND | 99
NY | 99
SC | 99
CT | 100
MI | 100
OH | 100
UT | 100
AZ | 101
CA | 101
FL | 101
GA | 101
ME | 101
MN | 101
NJ | 101
DE | 102
IN | 102
KS | 102
NJ | 102
SC | 102
MD | 103
VA | 103
AZ | 104
IL | 104
MA | 104
PA | 104
VA | 104
IL | 105
IL | 105
MD | 105
CA | 106
FL | 106
IA | 106
ID | 106
MI | 106
NY | 106
OR | 106
PA | 106
TX | 106
TX | 106
MA | 107
MO | 107
NY | 107
OH | 107
PA | 107
NY | 108
CA | 109
OH | 109
AZ | 110
KS | 110
MA | 110
OR | 110
CA | 111
CA | 111
IN | 111
MI | 111
MN | 111
NY | 111
NY | 111
SC | 111
MI | 112
OK | 112
TN | 112
TX | 112
WI | 112
CA | 113
LA | 113
RI | 113
UT | 113
IL | 114
WI | 114
AL | 115
MA | 115
VA | 115
VA | 116
WI | 116
CA | 117
CA | 117
FL | 117
IA | 117
MD | 117
FL | 118
KS | 118
NC | 118
NH | 118
TX | 118
MN | 119
TX | 119
CA | 120
MS | 120
TX | 120
CA | 121
CA | 121
MN | 121
OH | 121
AZ | 123
MA | 123
NC | 123
NE | 123
TX | 123
WA | 123
MD | 124
IA | 125
IL | 125
CA | 126
FL | 126
MA | 127
MD | 127
OH | 127
NY | 128
CO | 129
MO | 129
TX | 129
IN | 130
KS | 131
NE | 131
NY | 131
CT | 132
NJ | 132
NY | 133
NY | 133
RI | 134
TX | 135
UT | 135
MO | 136
OH | 136
SC | 136
DE | 137
MI | 137
OR | 137
VA | 137
CA | 138
MD | 138
MD | 138
WI | 138
TN | 139
MA | 140
NY | 140
PA | 140
TX | 140
CA | 141
CT | 141
WI | 141
CA | 142
NY | 142
NY | 142
CO | 143
MA | 143
MI | 143
NC | 143
NC | 143
GA | 144
PA | 144
PA | 145
SC | 145
SC | 146
WA | 146
OR | 147
PA | 147
SC | 147
HI | 148
KS | 149
MA | 149
MA | 150
GA | 151
VA | 151
CA | 152
CA | 152
MN | 152
NH | 152
FL | 153
PR | 153
AR | 154
CT | 154
UT | 154
IN | 155
TX | 155
CT | 156
FL | 156
KY | 156
PA | 156
UT | 156
WI | 156
CT | 157
CA | 158
KY | 158
NY | 158
CA | 159
IA | 159
KY | 159
WA | 159
MI | 160
MI | 160
OR | 160
PR | 160
WA | 160
CA | 161
NY | 161
WA | 161
AZ | 162
VA | 164
FL | 165
MA | 165
MA | 165
MA | 165
MI | 165
TX | 165
GA | 166
MI | 166
NY | 166
OK | 166
PA | 166
IL | 167
FL | 168
TX | 168
MD | 169
LA | 170
DC | 171
OR | 171
WA | 171
NY | 172
TX | 172
AL | 174
CA | 174
IN | 174
NV | 174
OR | 174
CO | 175
MI | 175
VA | 175
KY | 176
MI | 176
OH | 176
OH | 177
GA | 178
MI | 178
WA | 178
IL | 179
KY | 179
MN | 179
AL | 182
MO | 183
CA | 185
MO | 185
NJ | 185
NY | 186
OK | 187
KS | 188
AL | 189
CA | 189
TN | 189
CA | 190
GA | 190
PA | 190
RI | 190
NY | 191
PA | 192
AR | 193
AZ | 193
MD | 193
WI | 193
MO | 194
NJ | 194
CO | 196
MI | 196
TX | 197
MN | 198
UT | 198
IL | 199
IL | 200
MN | 200
OR | 200
IN | 201
CA | 202
KS | 202
IL | 203
OR | 203
CA | 204
IN | 204
OH | 204
TX | 205
CO | 206
NC | 206
MS | 207
CO | 208
CA | 209
IN | 210
FL | 211
TX | 211
NJ | 215
MD | 216
IL | 217
NC | 217
TX | 218
CA | 219
VA | 219
WI | 219
NJ | 220
IL | 221
OH | 221
NE | 222
SC | 223
OR | 224
MI | 225
WI | 225
NJ | 226
WA | 226
TX | 227
IA | 228
MA | 228
UT | 228
IN | 229
NC | 229
MO | 230
NE | 230
GA | 231
IL | 231
NV | 231
CA | 232
PA | 232
TX | 232
MO | 233
NY | 233
CA | 234
FL | 234
PA | 234
NJ | 235
OH | 236
MO | 237
NJ | 237
NC | 239
GA | 240
NJ | 240
NY | 240
NJ | 241
TX | 241
VA | 241
WI | 241
RI | 242
NY | 243
IN | 244
OH | 246
LA | 247
MI | 247
MN | 248
OR | 249
TX | 249
NJ | 250
CA | 252
CT | 252
CA | 253
LA | 254
AZ | 256
IL | 256
NC | 256
VA | 256
IN | 257
FL | 258
PA | 258
GA | 259
MI | 261
PA | 262
IL | 263
CA | 266
TX | 266
KY | 269
TX | 270
OH | 271
TN | 272
UT | 272
OR | 273
MI | 276
ID | 277
KY | 277
MI | 277
AR | 278
AZ | 278
IL | 278
WI | 280
VA | 283
NY | 284
CA | 285
CT | 285
MA | 285
MI | 285
NC | 285
NC | 285
GA | 286
MD | 286
NJ | 286
IN | 287
SC | 288
NJ | 289
TX | 289
AZ | 292
OK | 293
IA | 294
WI | 296
IA | 298
CA | 301
MI | 301
MO | 301
IN | 302
MD | 303
MD | 303
NY | 303
NY | 303
WI | 304
SD | 306
CT | 308
FL | 308
MN | 309
KY | 310
MO | 310
FL | 311
NY | 316
OR | 316
RI | 316
TN | 318
WI | 318
NY | 319
PA | 319
CA | 322
FL | 324
GA | 324
NY | 325
NY | 325
KS | 326
LA | 328
VA | 328
AZ | 329
GA | 330
NY | 330
TX | 330
NC | 331
CA | 332
CA | 332
WA | 333
OH | 334
PA | 335
NY | 337
UT | 337
CA | 344
IL | 344
VA | 344
WI | 344
MN | 347
VA | 347
IN | 348
KS | 348
HI | 350
KY | 354
IA | 355
NY | 355
TX | 356
OH | 357
OH | 357
ME | 358
ND | 363
OK | 363
TX | 364
VA | 367
PA | 368
VA | 368
WA | 369
IN | 370
CA | 371
CA | 371
MI | 376
NJ | 376
MO | 377
NJ | 378
AR | 381
GA | 382
MS | 382
PA | 382
OH | 383
OH | 384
FL | 386
CA | 391
NJ | 391
AZ | 392
IN | 392
AL | 393
FL | 393
WA | 394
IN | 395
FL | 396
NY | 396
TX | 399
MO | 404
IL | 405
TX | 406
NC | 408
AK | 409
ND | 411
TX | 414
TX | 415
OH | 418
WV | 418
FL | 419
CO | 422
MI | 423
OH | 423
NH | 425
OH | 426
VA | 426
MN | 428
NY | 432
DE | 433
NY | 434
MO | 435
PR | 440
CA | 445
IA | 445
ME | 446
MN | 454
CA | 456
TN | 467
GA | 470
FL | 474
CO | 475
NY | 477
VA | 478
FL | 483
MA | 483
FL | 484
NY | 485
CA | 489
NY | 490
MI | 498
SC | 498
IL | 499
MA | 503
MA | 505
NC | 507
PA | 508
TN | 509
KS | 518
KS | 523
IL | 524
WI | 525
CT | 526
CA | 531
OH | 531
MO | 532
OH | 534
MD | 536
CA | 539
FL | 539
PA | 539
MI | 545
WV | 547
TN | 550
NY | 557
GA | 560
TX | 565
IL | 569
WI | 575
CA | 584
TN | 601
MO | 604
MD | 607
FL | 609
NY | 626
FL | 629
MD | 629
OR | 630
MI | 634
KS | 636
MI | 646
TX | 649
MN | 652
WA | 653
NJ | 656
CO | 664
CA | 667
AR | 706
CA | 706
MI | 724
PA | 728
MD | 732
NY | 732
PA | 741
CA | 748
CO | 778
FL | 780
PA | 790
MO | 798
CO | 812
WI | 824
CT | 834
KY | 836
OH | 871
TN | 878
AZ | 881
MO | 893
LA | 914
IN | 948
PA | 982
PA | 997
AZ | 1039
KY | 1131
TX | 1192
NY | 1202
OH | 1237
CT | 1877
PA | 2030
IL | 5905
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CA | 0
CO | 0
CO | 0
CO | 0
CO | 0
CT | 0
FL | 0
FL | 0
FL | 0
FL | 0
FL | 0
FL | 0
FL | 0
FL | 0
FL | 0
FL | 0
FL | 0
GA | 0
GA | 0
GA | 0
GA | 0
GA | 0
HI | 0
IL | 0
IL | 0
IL | 0
IL | 0
IL | 0
IN | 0
KS | 0
KY | 0
KY | 0
KY | 0
LA | 0
LA | 0
LA | 0
MD | 0
MD | 0
MD | 0
MD | 0
MD | 0
MD | 0
MI | 0
MI | 0
MI | 0
MI | 0
MI | 0
MN | 0
MN | 0
MN | 0
MN | 0
MO | 0
MO | 0
MS | 0
MT | 0
MT | 0
NC | 0
NC | 0
NC | 0
NC | 0
NC | 0
NC | 0
ND | 0
NE | 0
NH | 0
NJ | 0
NJ | 0
NJ | 0
NJ | 0
NY | 0
NY | 0
NY | 0
NY | 0
NY | 0
NY | 0
NY | 0
NY | 0
NY | 0
NY | 0
NY | 0
NY | 0
OH | 0
OH | 0
OH | 0
OH | 0
OH | 0
OH | 0
OK | 0
OK | 0
OK | 0
OK | 0
OK | 0
OR | 0
PA | 0
PA | 0
PA | 0
RI | 0
SC | 0
SC | 0
SD | 0
TN | 0
TN | 0
TN | 0
TN | 0
TN | 0
TX | 0
TX | 0
TX | 0
TX | 0
TX | 0
TX | 0
TX | 0
TX | 0
TX | 0
TX | 0
UT | 0
UT | 0
VA | 0
VA | 0
VA | 0
VA | 0
WA | 0
WA | 0
WA | 0
WI | 0
WI | 0
WI | 0
WI | 0
WY | 0