Spreadsheet: 751840d1634371308-if-and-and-search-formula-aged-debtor-small
Sheet: Sheet1

Order | Company Name | Type | Type 2 | Invoice No | Invoice Date | Invoice Value
1 | Company 10 | A | SI | INV 123456 | 2019-01-01 00:00:00 | 110
2 | Company 2 | A | SI | INV 123457 | 2021-10-09 00:00:00 | 109
3 | Company 10 | B | SI | INV 123458 | 2019-09-20 00:00:00 | 206
4 | Company 1 | A | SI | INV 123459 | 2019-11-21 00:00:00 | 231
5 | Company 7 | B | SI | INV 123460 | 2020-04-08 00:00:00 | 164
6 | Company 2 | B | SI | INV 123461 | 2019-11-17 00:00:00 | 181
7 | Company 10 | A | SI | INV 123462 | 2019-11-06 00:00:00 | 187
8 | Company 8 | A | SI | INV 123463 | 2019-08-18 00:00:00 | 12
9 | Company 5 | A | SI | INV 123464 | 2019-03-18 00:00:00 | 184
10 | Company 4 | A | SI | INV 123465 | 2020-08-22 00:00:00 | 190
11 | Company 5 | A | SI | INV 123466 | 2021-01-05 00:00:00 | 158
12 | Company 10 | B | SI | INV 123467 | 2019-05-02 00:00:00 | 249
13 | Company 8 | B | SI | INV 123468 | 2019-12-26 00:00:00 | 228
14 | Company 3 | A | SI | INV 123469 | 2021-03-11 00:00:00 | 151
15 | Company 3 | A | SI | INV 123470 | 2020-01-26 00:00:00 | 179
16 | Company 7 | A | SI | INV 123471 | 2019-08-07 00:00:00 | 166
17 | Company 3 | B | SI | INV 123472 | 2020-11-09 00:00:00 | 244
18 | Company 6 | A | SI | INV 123473 | 2021-09-14 00:00:00 | 217
19 | Company 5 | A | SI | INV 123474 | 2020-03-18 00:00:00 | 188
20 | Company 9 | B | SI | INV 123475 | 2021-02-26 00:00:00 | 137
21 | Company 2 | B | SI | INV 123476 | 2021-09-17 00:00:00 | 179
22 | Company 4 | A | SI | INV 123477 | 2020-07-25 00:00:00 | 72
23 | Company 8 | A | SI | INV 123478 | 2020-07-09 00:00:00 | 123
24 | Company 9 | B | SI | INV 123479 | 2019-06-26 00:00:00 | 244
25 | Company 3 | A | SI | INV 123480 | 2019-01-01 00:00:00 | 162
26 | Company 8 | B | SI | INV 123481 | 2021-10-09 00:00:00 | 198
27 | Company 3 | B | SI | INV 123482 | 2019-09-20 00:00:00 | 97
28 | Company 3 | A | SI | INV 123483 | 2019-11-21 00:00:00 | 245
29 | Company 9 | A | SI | INV 123484 | 2020-04-08 00:00:00 | 165
30 | Company 4 | A | SI | INV 123485 | 2019-11-17 00:00:00 | 102
31 | Company 2 | A | SI | INV 123486 | 2019-11-06 00:00:00 | 204
32 | Company 8 | A | SI | INV 123487 | 2019-08-18 00:00:00 | 112
33 | Company 9 | B | SI | INV 123488 | 2019-03-18 00:00:00 | 24
34 | Company 4 | B | SI | INV 123489 | 2020-08-22 00:00:00 | 232
35 | Company 10 | A | SI | INV 123490 | 2021-01-05 00:00:00 | 177
36 | Company 4 | A | SI | INV 123491 | 2019-05-02 00:00:00 | 90
37 | Company 3 | A | SI | INV 123492 | 2019-12-26 00:00:00 | 161
38 | Company 9 | B | SI | INV 123493 | 2021-03-11 00:00:00 | 13
39 | Company 1 | A | SI | INV 123494 | 2020-01-26 00:00:00 | 132
40 | Company 4 | A | SI | INV 123495 | 2019-08-07 00:00:00 | 20
41 | Company 3 | B | SI | INV 123496 | 2020-11-09 00:00:00 | 202
42 | Company 8 | B | SI | INV 123497 | 2021-09-14 00:00:00 | 241
43 | Company 3 | A | SI | INV 123498 | 2020-03-18 00:00:00 | 119
44 | Company 6 | A | SI | INV 123499 | 2021-02-26 00:00:00 | 109
45 | Company 5 | B | SI | INV 123500 | 2021-09-17 00:00:00 | 50
46 | Company 2 | A | SI | INV 123501 | 2020-07-25 00:00:00 | 140
47 | Company 6 | B | SI | INV 123502 | 2020-07-09 00:00:00 | 183
48 | Company 7 | B | SI | INV 123503 | 2019-06-26 00:00:00 | 18
49 | Company 6 | A | SI | INV 123504 | 2019-01-01 00:00:00 | 217
50 | Company 8 | A | SI | INV 123505 | 2021-10-09 00:00:00 | 137
51 | Company 1 | A | SI | INV 123506 | 2019-09-20 00:00:00 | 227
52 | Company 2 | A | SI | INV 123507 | 2019-11-21 00:00:00 | 73
53 | Company 7 | A | SI | INV 123508 | 2020-04-08 00:00:00 | 75
54 | Company 4 | B | SI | INV 123509 | 2019-11-17 00:00:00 | 152
55 | Company 5 | B | SI | INV 123510 | 2019-11-06 00:00:00 | 138
56 | Company 1 | A | SI | INV 123511 | 2019-08-18 00:00:00 | 29
57 | Company 6 | A | SI | INV 123512 | 2019-03-18 00:00:00 | 170
58 | Company 5 | A | SI | INV 123513 | 2020-08-22 00:00:00 | 8
59 | Company 2 | B | SI | INV 123514 | 2021-01-05 00:00:00 | 55
60 | Company 5 | A | SI | INV 123515 | 2019-05-02 00:00:00 | 156
61 | Company 10 | A | SI | INV 123516 | 2019-12-26 00:00:00 | 67
62 | Company 5 | B | SI | INV 123517 | 2021-03-11 00:00:00 | 13
63 | Company 6 | B | SI | INV 123518 | 2020-01-26 00:00:00 | 47
64 | Company 10 | A | SI | INV 123519 | 2019-08-07 00:00:00 | 183
65 | Company 7 | A | SI | INV 123520 | 2020-11-09 00:00:00 | 77
66 | Company 4 | B | SI | INV 123521 | 2021-09-14 00:00:00 | 92
67 | Company 10 | A | SI | INV 123522 | 2020-03-18 00:00:00 | 123
68 | Company 1 | B | SI | INV 123523 | 2021-02-26 00:00:00 | 69
69 | Company 4 | B | SI | INV 123524 | 2021-09-17 00:00:00 | 78
70 | Company 7 | A | SI | INV 123525 | 2020-07-25 00:00:00 | 227
71 | Company 3 | A | SI | INV 123526 | 2020-07-09 00:00:00 | 188
72 | Company 2 | A | SI | INV 123527 | 2019-06-26 00:00:00 | 245
73 | Company 5 | A | SI | INV 123528 | 2021-06-21 00:00:00 | 65
74 | Company 10 | A | SI | INV 123529 | 2019-06-02 00:00:00 | 62
75 | Company 6 | B | SI | INV 123530 | 2020-09-06 00:00:00 | 249
76 | Company 10 | B | SI | INV 123531 | 2020-06-13 00:00:00 | 116
77 | Company 6 | A | SI | INV 123532 | 2021-06-13 00:00:00 | 55
78 | Company 1 | A | SI | INV 123533 | 2019-05-20 00:00:00 | 80
79 | Company 8 | A | SI | INV 123534 | 2020-01-13 00:00:00 | 126
80 | Company 7 | B | SI | INV 123535 | 2019-12-31 00:00:00 | 81
81 | Company 2 | A | SI | INV 123536 | 2019-03-10 00:00:00 | 132
82 | Company 1 | A | SI | INV 123537 | 2019-06-16 00:00:00 | 83
83 | Company 1 | B | SI | INV 123538 | 2021-09-18 00:00:00 | 77
84 | Company 3 | B | SI | INV 123539 | 2020-04-29 00:00:00 | 12
85 | Company 5 | A | SI | INV 123540 | 2020-10-01 00:00:00 | 202
86 | Company 1 | A | SI | INV 123541 | 2021-03-07 00:00:00 | 154
87 | Company 7 | B | SI | INV 123542 | 2019-04-17 00:00:00 | 3
88 | Company 2 | A | SI | INV 123543 | 2021-07-15 00:00:00 | 159
89 | Company 2 | B | SI | INV 123544 | 2021-03-24 00:00:00 | 64
90 | Company 7 | B | SI | INV 123545 | 2020-07-16 00:00:00 | 130
91 | Company 9 | A | SI | INV 123546 | 2021-09-03 00:00:00 | 5
92 | Company 7 | A | SI | INV 123547 | 2019-01-02 00:00:00 | 177
93 | Company 5 | A | SI | INV 123548 | 2020-04-15 00:00:00 | 101
94 | Company 3 | A | SI | INV 123549 | 2021-08-09 00:00:00 | 134
95 | Company 6 | A | SI | INV 123550 | 2019-08-11 00:00:00 | 105
96 | Company 5 | B | SI | INV 123551 | 2019-06-08 00:00:00 | 2
97 | Company 9 | B | SI | INV 123552 | 2019-05-11 00:00:00 | 17
98 | Company 1 | A | SI | INV 123553 | 2020-03-10 00:00:00 | 53
99 | Company 3 | A | SI | INV 123554 | 2019-06-06 00:00:00 | 93
100 | Company 1 | A | SI | INV 123555 | 2020-03-23 00:00:00 | 108
101 | Company 3 | B | SI | INV 123556 | 2021-04-15 00:00:00 | 207
102 | Company 6 | A | SI | INV 123557 | 2020-09-20 00:00:00 | 46
103 | Company 7 | A | SI | INV 123558 | 2020-07-02 00:00:00 | 159
104 | Company 1 | B | SI | INV 123559 | 2021-08-12 00:00:00 | 10
105 | Company 8 | B | SI | INV 123560 | 2020-02-13 00:00:00 | 142
106 | Company 2 | A | SI | INV 123561 | 2021-01-02 00:00:00 | 195
107 | Company 5 | A | SI | INV 123562 | 2021-07-20 00:00:00 | 56
108 | Company 7 | B | SI | INV 123563 | 2020-03-28 00:00:00 | 198
109 | Company 10 | A | SI | INV 123564 | 2020-05-13 00:00:00 | 55
110 | Company 2 | B | SI | INV 123565 | 2021-09-24 00:00:00 | 85
111 | Company 8 | B | SI | INV 123566 | 2020-09-07 00:00:00 | 101
112 | Company 2 | A | SI | INV 123567 | 2021-08-12 00:00:00 | 177
113 | Company 5 | A | SI | INV 123568 | 2019-04-28 00:00:00 | 227
114 | Company 1 | A | SI | INV 123569 | 2020-02-22 00:00:00 | 108
115 | Company 7 | A | SI | INV 123570 | 2020-09-15 00:00:00 | 65
116 | Company 7 | A | SI | INV 123571 | 2020-07-14 00:00:00 | 179
117 | Company 5 | B | SI | INV 123572 | 2020-07-15 00:00:00 | 138
118 | Company 5 | B | SI | INV 123573 | 2019-06-18 00:00:00 | 153
119 | Company 5 | A | SI | INV 123574 | 2021-04-30 00:00:00 | 132
120 | Company 8 | A | SI | INV 123575 | 2020-11-17 00:00:00 | 227
121 | Company 7 | A | SI | INV 123576 | 2019-02-08 00:00:00 | 101
122 | Company 2 | B | SI | INV 123577 | 2020-03-06 00:00:00 | 214
123 | Company 3 | A | SI | INV 123578 | 2021-03-06 00:00:00 | 13
124 | Company 4 | A | SI | INV 123579 | 2020-11-04 00:00:00 | 119
125 | Company 6 | B | SI | INV 123580 | 2020-09-30 00:00:00 | 160
126 | Company 3 | B | SI | INV 123581 | 2020-02-28 00:00:00 | 92
127 | Company 8 | A | SI | INV 123582 | 2021-04-01 00:00:00 | 250
128 | Company 1 | A | SI | INV 123583 | 2020-05-30 00:00:00 | 191
129 | Company 6 | B | SI | INV 123584 | 2021-09-18 00:00:00 | 114
130 | Company 1 | A | SI | INV 123585 | 2019-07-29 00:00:00 | 158
131 | Company 3 | B | SI | INV 123586 | 2019-11-04 00:00:00 | 172
132 | Company 5 | B | SI | INV 123587 | 2021-02-17 00:00:00 | 43
133 | Company 8 | A | SI | INV 123588 | 2020-06-14 00:00:00 | 73
134 | Company 1 | A | SI | INV 123589 | 2020-02-19 00:00:00 | 89
134 | Company 2 | A | SC | INV 123590 | 2019-09-30 00:00:00 | 99
134 | Company 8 | A | SC | INV 123591 | 2020-04-09 00:00:00 | 140
134 | Company 2 | B | SC | INV 123592 | 2020-01-05 00:00:00 | 44
134 | Company 5 | A | SC | INV 123593 | 2021-09-27 00:00:00 | 81
134 | Company 1 | B | SC | INV 123594 | 2020-08-25 00:00:00 | 111
134 | Company 7 | B | SC | INV 123595 | 2020-08-07 00:00:00 | 199
134 | Company 7 | A | SC | INV 123596 | 2021-10-02 00:00:00 | 49
134 | Company 5 | A | SC | INV 123597 | 2021-06-16 00:00:00 | 65
134 | Company 5 | A | SC | INV 123598 | 2019-03-20 00:00:00 | 246
134 | Company 5 | A | SC | INV 123599 | 2019-05-11 00:00:00 | 128
134 | Company 8 | A | SC | INV 123600 | 2019-10-26 00:00:00 | 106
134 | Company 7 | B | SC | INV 123601 | 2020-08-29 00:00:00 | 203
134 | Company 2 | B | SC | INV 123602 | 2020-03-02 00:00:00 | 69
134 | Company 3 | A | SC | INV 123603 | 2019-08-16 00:00:00 | 170
134 | Company 4 | A | SC | INV 123604 | 2020-10-10 00:00:00 | 129
134 | Company 6 | A | SC | INV 123605 | 2020-11-13 00:00:00 | 130
134 | Company 3 | B | SC | INV 123606 | 2019-03-15 00:00:00 | 66
134 | Company 8 | A | SC | INV 123607 | 2020-07-29 00:00:00 | 179
134 | Company 1 | A | SC | INV 123608 | 2019-12-23 00:00:00 | 146
134 | Company 6 | B | SC | INV 123609 | 2020-04-25 00:00:00 | 159
134 | Company 1 | B | SC | INV 123610 | 2020-10-20 00:00:00 | 189
134 | Company 3 | A | SC | INV 123611 | 2020-03-17 00:00:00 | 179
134 | Company 5 | A | SC | INV 123612 | 2020-11-18 00:00:00 | 222
134 | Company 8 | B | SC | INV 123613 | 2020-11-29 00:00:00 | 237
134 | Company 1 | A | SC | INV 123614 | 2019-07-08 00:00:00 | 232
134 | Company 2 | B | SC | INV 123615 | 2019-02-03 00:00:00 | 98
134 | Company 8 | B | SC | INV 123616 | 2019-01-02 00:00:00 | 204
134 | Company 2 | A | SC | INV 123617 | 2019-06-13 00:00:00 | 170
134 | Company 5 | A | SC | INV 123618 | 2019-12-02 00:00:00 | 45
134 | Company 1 | A | SC | INV 123619 | 2019-02-07 00:00:00 | 78
134 | Company 7 | A | SC | INV 123620 | 2020-10-26 00:00:00 | 112
134 | Company 7 | A | SC | INV 123621 | 2019-03-05 00:00:00 | 170
134 | Company 5 | B | SC | INV 123622 | 2019-11-08 00:00:00 | 191
134 | Company 5 | B | SC | INV 123623 | 2020-06-19 00:00:00 | 145
134 | Company 5 | A | SC | INV 123624 | 2021-08-18 00:00:00 | 119
134 | Company 8 | A | SC | INV 123625 | 2019-10-22 00:00:00 | 70
134 | Company 7 | A | SC | INV 123626 | 2019-03-24 00:00:00 | 147
134 | Company 2 | B | SC | INV 123627 | 2019-07-20 00:00:00 | 215
134 | Company 3 | A | SC | INV 123628 | 2020-06-03 00:00:00 | 201
134 | Company 4 | A | SC | INV 123629 | 2020-11-09 00:00:00 | 225
134 | Company 6 | B | SC | INV 123630 | 2021-09-14 00:00:00 | 234
134 | Company 3 | B | SC | INV 123631 | 2020-03-18 00:00:00 | 240
134 | Company 8 | A | SC | INV 123632 | 2021-02-26 00:00:00 | 237
134 | Company 1 | A | SC | INV 123633 | 2021-09-17 00:00:00 | 35
134 | Company 6 | B | SC | INV 123634 | 2020-07-25 00:00:00 | 39
134 | Company 1 | A | SC | INV 123635 | 2020-07-09 00:00:00 | 203
134 | Company 3 | B | SC | INV 123636 | 2019-06-26 00:00:00 | 157
134 | Company 5 | B | SC | INV 123637 | 2021-06-21 00:00:00 | 125
134 | Company 8 | A | SC | INV 123638 | 2019-06-02 00:00:00 | 33
134 | Company 1 | A | SC | INV 123639 | 2020-09-06 00:00:00 | 245
134 | Company 2 | A | SC | INV 123640 | 2020-06-13 00:00:00 | 122
134 | Company 8 | A | SC | INV 123641 | 2021-06-13 00:00:00 | 22
134 | Company 2 | A | SC | INV 123642 | 2019-05-20 00:00:00 | 241
134 | Company 5 | B | SC | INV 123643 | 2020-01-13 00:00:00 | 24
134 | Company 1 | B | SC | INV 123644 | 2019-12-31 00:00:00 | 53
134 | Company 7 | A | SC | INV 123645 | 2020-11-09 00:00:00 | 156
134 | Company 7 | A | SC | INV 123646 | 2021-09-14 00:00:00 | 125
134 | Company 5 | A | SC | INV 123647 | 2020-03-18 00:00:00 | 13
134 | Company 5 | B | SC | INV 123648 | 2021-02-26 00:00:00 | 147
134 | Company 5 | A | SC | INV 123649 | 2021-09-17 00:00:00 | 247
134 | Company 8 | A | SC | INV 123650 | 2020-07-25 00:00:00 | 119
134 | Company 7 | B | SC | INV 123651 | 2020-07-09 00:00:00 | 244
134 | Company 2 | B | SC | INV 123652 | 2019-06-26 00:00:00 | 78
134 | Company 3 | A | SC | INV 123653 | 2021-06-21 00:00:00 | 47
134 | Company 4 | A | SC | INV 123654 | 2019-06-02 00:00:00 | 129
134 | Company 6 | B | SC | INV 123655 | 2020-09-06 00:00:00 | 91
134 | Company 3 | A | SC | INV 123656 | 2020-06-13 00:00:00 | 156
134 | Company 8 | B | SC | INV 123657 | 2021-06-13 00:00:00 | 57
134 | Company 1 | B | SC | INV 123658 | 2019-05-20 00:00:00 | 220
134 | Company 6 | A | SC | INV 123659 | 2020-01-13 00:00:00 | 39
134 | Company 1 | A | SC | INV 123660 | 2019-12-31 00:00:00 | 178
134 | Company 3 | A | SC | INV 123661 | 2020-11-09 00:00:00 | 150
134 | Company 5 | A | SC | INV 123662 | 2021-09-14 00:00:00 | 142
134 | Company 8 | A | SC | INV 123663 | 2020-03-18 00:00:00 | 179
134 | Company 8 | B | SC | INV 123664 | 2021-02-26 00:00:00 | 194
134 | Company 1 | B | SC | INV 123665 | 2021-09-17 00:00:00 | 175
134 | Company 1 | A | SC | INV 123666 | 2020-07-25 00:00:00 | 80