Spreadsheet: 854778d1704534357-need-help-to-identify-new-customers-and-sales-by-quarter-sample-1-
Sheet: Sales

Actual Data |  |  |  |  |  |  |  | Required
[NAME] | Customer | Product | Ship Date | Quantity | Value
1 | Customer 1 | AAA | 2022-01-01 00:00:00 | 207 | 1068 |  |  | Total and New Products sales
2 | Customer 2 | BBB | 2022-01-17 00:00:00 | 223 | 1358 |  |  | Sales | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023
3 | Customer 3 | CCC | 2022-01-01 00:00:00 | 313 | 889 |  |  | Total |  | 18377 | 0 | 0 | 16839 | 15223 | 0 | 0
4 | Customer 4 | ABC | 2022-01-29 00:00:00 | 101 | 867 |  |  | New | 0
5 | Customer 5 | VCC | 2022-01-01 00:00:00 | 122 | 1366
1 | Customer 1 | AAA | 2022-02-11 00:00:00 | 151 | 988 |  |  | Total and New Customers
2 | Customer 2 | BBB | 2022-02-12 00:00:00 | 274 | 884 |  |  | Sales | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023
3 | Customer 3 | CCC | 2022-02-10 00:00:00 | 164 | 1352 |  |  | Total
4 | Customer 4 | ABC | 2022-02-05 00:00:00 | 154 | 1337 |  |  | New | 0 |  |  |  | 0
5 | Customer 5 | VCC | 2022-02-20 00:00:00 | 282 | 881
1 | Customer 1 | AAA | 2022-03-11 00:00:00 | 330 | 930
2 | Customer 2 | BBB | 2022-03-12 00:00:00 | 369 | 1157
3 | Customer 3 | CCC | 2022-03-10 00:00:00 | 208 | 1285
4 | Customer 4 | ABC | 2022-03-05 00:00:00 | 120 | 1058
5 | Customer 5 | VCC | 2022-03-20 00:00:00 | 326 | 564
1 | Customer 1 | AAA | 2022-04-11 00:00:00 | 112 | 508
1 | Customer 1 | ABB | 2022-04-11 00:00:00 | 278 | 1049
2 | Customer 2 | BBB | 2022-04-12 00:00:00 | 176 | 626
2 | Customer 2 | FFF | 2022-04-12 00:00:00 | 206 | 1265
3 | Customer 3 | CCC | 2022-04-10 00:00:00 | 355 | 1480
4 | Customer 4 | ABC | 2022-04-05 00:00:00 | 137 | 1472
5 | Customer 5 | VCC | 2022-04-20 00:00:00 | 339 | 645
1 | Customer 1 | AAA | 2022-05-11 00:00:00 | 186 | 1175
11 | Customer 11 | TT.3 | 2022-05-11 00:00:00 | 186 | 555
2 | Customer 2 | BBB | 2022-05-12 00:00:00 | 393 | 631
3 | Customer 3 | CCC | 2022-05-05 00:00:00 | 170 | 687
4 | Customer 4 | ABC | 2022-05-08 00:00:00 | 140 | 1411
5 | Customer 5 | VCC | 2022-05-17 00:00:00 | 219 | 1250
1 | Customer 1 | AAA | 2022-06-02 00:00:00 | 321 | 636
2 | Customer 2 | BBB | 2022-06-06 00:00:00 | 212 | 929
3 | Customer 3 | CCC | 2022-06-09 00:00:00 | 254 | 594
4 | Customer 4 | ABC | 2022-06-08 00:00:00 | 351 | 1080
5 | Customer 5 | VCC | 2022-06-17 00:00:00 | 327 | 1412
5 | Customer 5 | VFR | 2022-06-17 00:00:00 | 261 | 972
1 | Customer 1 | AAA | 2023-01-01 00:00:00 | 179 | 520
1 | Customer 1 | MMM | 2023-01-01 00:00:00 | 381 | 549
2 | Customer 2 | BBB | 2023-01-17 00:00:00 | 274 | 1201
3 | Customer 3 | CCC | 2023-01-01 00:00:00 | 250 | 699
4 | Customer 4 | ABC | 2023-01-29 00:00:00 | 292 | 1295
5 | Customer 5 | VCC | 2023-01-01 00:00:00 | 348 | 1173
1 | Customer 1 | AAA | 2023-02-11 00:00:00 | 146 | 1159
2 | Customer 2 | BBB | 2023-02-12 00:00:00 | 285 | 1228
3 | Customer 3 | CCC | 2023-02-10 00:00:00 | 332 | 799
3 | Customer 3 | PPP | 2023-02-10 00:00:00 | 269 | 798
4 | Customer 4 | ABC | 2023-02-05 00:00:00 | 263 | 982
5 | Customer 5 | VCC | 2023-02-20 00:00:00 | 213 | 678
1 | Customer 1 | AAA | 2023-03-11 00:00:00 | 130 | 805
2 | Customer 2 | BBB | 2023-03-12 00:00:00 | 176 | 1470
3 | Customer 3 | CCC | 2023-03-10 00:00:00 | 152 | 1232
4 | Customer 4 | ABC | 2023-03-05 00:00:00 | 143 | 902
5 | Customer 5 | VCC | 2023-03-20 00:00:00 | 202 | 1349
1 | Customer 1 | AAA | 2023-04-11 00:00:00 | 177 | 591
2 | Customer 2 | BBB | 2023-04-12 00:00:00 | 301 | 1366
3 | Customer 3 | CCC | 2023-04-10 00:00:00 | 226 | 1360
4 | Customer 4 | ABC | 2023-04-05 00:00:00 | 271 | 1419
5 | Customer 5 | VCC | 2023-04-20 00:00:00 | 320 | 833
1 | Customer 1 | AAA | 2023-05-11 00:00:00 | 368 | 887
2 | Customer 2 | BBB | 2023-05-12 00:00:00 | 133 | 504
3 | Customer 3 | CCC | 2023-05-05 00:00:00 | 378 | 1099
4 | Customer 4 | ABC | 2023-05-08 00:00:00 | 369 | 631
5 | Customer 5 | VCC | 2023-05-17 00:00:00 | 348 | 660
1 | Customer 1 | AAA | 2023-06-02 00:00:00 | 369 | 594
2 | Customer 2 | BBB | 2023-06-06 00:00:00 | 387 | 1139
3 | Customer 3 | CCC | 2023-06-09 00:00:00 | 185 | 1242
4 | Customer 4 | ABC | 2023-06-08 00:00:00 | 235 | 924
5 | Customer 5 | VCC | 2023-06-17 00:00:00 | 267 | 1055
5 | Customer 5 | VFR | 2023-06-17 00:00:00 | 138 | 719
55 | Customer 55 | ABCD | 2023-06-17 00:00:00 | 138 | 200