Spreadsheet: 701224d1603632224-struggling-with-new-filter-array-formula-with-non-adjacent-columns-getting-value-test-filter-array
Sheet: DETAILS 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERIOD | DEPT | CCY | STATUS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 Months > | Sea Import | EUR
PERIOD | INVOICE No | DATE | ORDER No | DEPT | CUSTOMER | TOTAL | SETTLEMENT | BALANCE | CCY | STATUS | REMARKS |  |  |  |  | PERIOD | DEPT | CUSTOMER | TOTAL | SETTLEMENT | BALANCE | STATUS
2 Months > | DRN004906 | 2019-04-19 00:00:00 | QSQ | Air Export | SSS | 317 | 0 | 317 | EUR |  |  |  | CHASING |  |  |  | MD001788 | 43981 | 1123 | Sea Import | SFF | 300 | 0 | 300 | EUR | 0 | 0
1 Month | DRN005831 | 2020-09-23 00:00:00 | SSS | Air Import | FFF | 362.26 | 0 | 362.26 | USD |  |  |  | N/A |  |  | 2 Months > | DRN005764 | 44043 | 1125 | Sea Import | SDSF | 677 | 0 | 677 | EUR | 0 | 0
2 Months > | ALL011447 | 2017-06-09 00:00:00 | Partly allocated | Payment | FFF |  | -0.01 | -0.01 | USD |  |  |  | STMT |  |  | 2 Months > | DRN005695 | 43972 | 1147 | Sea Import | FSFS | 1480 | 0 | 1480 | EUR | 0 | 0
2 Months > | DRN005709 | 2020-06-11 00:00:00 | [NAME] | Air Import | [OA] - AMT | 276 | 0 | 276 | EUR |  |  |  | REMINDER 1 |  |  | 2 Months > | MD001296 | 43216 | 1165 | Sea Import | ETWGTW | 247.08 | -238.67 | 8.41 | EUR | 0 | 0
1 Month | DRN005806 | 2020-09-02 00:00:00 | DDD | Sea Import | UUU | 395 | 0 | 395 | USD |  |  |  | REMINDER 2
1 Month | DRN005848 | 2020-09-30 00:00:00 | SSS | Sea Import | RRTY | 404 | 0 | 404 | USD |  |  |  | REMINDER 3
1 Month | DRN005849 | 2020-09-30 00:00:00 | FFFF | Sea Import | DDD | 587.15 | 0 | 587.15 | USD |  |  |  | DROP CALL
Current | DRN005861 | 2020-10-08 00:00:00 | SSS | Sea Export | RRR | 50 | 0 | 50 | USD |  |  |  | SUCCESS CALL
Current | DRN005863 | 2020-10-13 00:00:00 | SFE00710FFFF20A | Sea Export | EEE | 1200 | 0 | 1200 | USD |  |  |  | PTP
Current | DRN005870 | 2020-10-15 00:00:00 | WWW | Sea Import | SSS | 938.9 | 0 | 938.9 | USD |  |  |  | CHEQUE IN PROCESS
Current | [NAME] | 2020-10-16 00:00:00 | Receipt not allocated | Payment | DDD |  | -65 | -65 | USD |  |  |  | CHEQUE AT SIGNATURE
2 Months > | DRN004256 | 2018-06-29 00:00:00 | 1111 | Air Import | EEE | 175 | 0 | 175 | USD |  |  |  | CHEQUE AT POST
2 Months > | DRN004707 | 2019-01-25 00:00:00 | 1112 | Air Export | GGTY | 293.25 | 0 | 293.25 | USD |  |  |  | Bank Transfer in process
2 Months > | DRN005580 | 2020-02-12 00:00:00 | 1113 | Sea Export | DFDFD | 20 | 0 | 20 | USD |  |  |  | PARTLY PAID
2 Months > | MD001163 | 2017-04-18 00:00:00 | 1114 | Sea Export | SDDSD | 45.16 | -45 | 0.16 | USD |  |  |  | ALLOCATION
2 Months > | DRN005503 | 2020-01-13 00:00:00 | 1115 | Sea Export | FFFF | 23.2 | 0 | 23.2 | USD |  |  |  | NO REMITTANCE
2 Months > | DRN005545 | 2020-01-29 00:00:00 | 1116 | Sea Export | TTTT | 36.48 | 0 | 36.48 | USD |  |  |  | ALLOCATED
2 Months > | [NAME] | 2020-02-17 00:00:00 | 1117 | Sea Export | FFFF | 35.08 | 0 | 35.08 | USD |  |  |  | CLEARED
2 Months > | DRN005626 | 2020-03-05 00:00:00 | 1118 | Sea Export | WEREWR | 34.5 | 0 | 34.5 | USD |  |  |  | DEFAULTER
2 Months > | DRN005633 | 2020-03-09 00:00:00 | 1119 | Sea Export | ERT | 32.5 | 0 | 32.5 | USD |  |  |  | SIGMA BUG
2 Months > | DRN005647 | 2020-03-16 00:00:00 | 1120 | Sea Export | FEFED | 81.1 | 0 | 81.1 | USD |  |  |  | MISSING INVOICES
2 Month | DRN005781 | 2020-08-11 00:00:00 | 1121 | Sea Export | GGG | 43.75 | 0 | 43.75 | USD |  |  |  | [NAME]
2 Month | DRN005782 | 2020-08-11 00:00:00 | 1122 | Sea Export | EGEWGE | 19.6 | 0 | 19.6 | USD |  |  |  | CREDIT NOTE
2 Months > | MD001788 | 2020-05-30 00:00:00 | 1123 | Sea Import | SFF | 300 | 0 | 300 | EUR |  |  |  | COLLECTION / IN TRANSIT
2 Months > | MD001790 | 2020-07-17 00:00:00 | 1124 | QD | [NAME] | 60 | 0 | 60 | EUR |  |  |  | APPROVED
2 Months > | DRN005764 | 2020-07-31 00:00:00 | 1125 | Sea Import | SDSF | 677 | 0 | 677 | EUR |  |  |  | CLAIM LETTER
2 Month | MD001799 | 2020-08-20 00:00:00 | 1126 | Sea Import | VVV | 80 | 0 | 80 | EUR |  |  |  | ATTORNEY
2 Month | DRN005809 | 2020-08-31 00:00:00 | 1127 | QD | Q | 360.93 | 0 | 360.93 | EUR |  |  |  | POTENTIAL B/DEBTS
1 Month | DRN005815 | 2020-09-10 00:00:00 | 1128 | Sea Import | RRRR | 42 | 0 | 42 | EUR |  |  |  | BAD DEBTS
1 Month | [NAME] | 2020-09-10 00:00:00 | 1129 | Sea Import | ERWET | 42 | 0 | 42 | EUR |  |  |  | WRITE OFF
1 Month | DRN005817 | 2020-09-10 00:00:00 | 1130 | Sea Import | [NAME] | 55 | 0 | 55 | EUR |  |  |  | WRITE BACK
1 Month | DRN005818 | 2020-09-10 00:00:00 | 1131 | Sea Import | [NAME] | 42 | 0 | 42 | EUR |  |  |  | CONTRA
1 Month | DRN005819 | 2020-09-10 00:00:00 | 1132 | Sea Import | GRSGERHY | 42 | 0 | 42 | EUR |  |  |  | CONTRA IFO CREDITOR
1 Month | DRN005854 | 2020-09-30 00:00:00 | 1133 | Sea Import | TYUTYU | 130 | 0 | 130 | EUR |  |  |  | CONTRA IFO DEBTOR
1 Month | DRN005855 | 2020-09-30 00:00:00 | 1134 | Sea Import | ASFE | 2027.7 | 0 | 2027.7 | EUR |  |  |  | PROFIT SHARE
1 Month | MD001815 | 2020-09-30 00:00:00 | 1135 | Sea Import | SGDHGDH | 391 | 0 | 391 | EUR |  |  |  | Followed by Accountable
2 Months > | [NAME] | 2020-05-19 00:00:00 | 1136 | Air Export | YUKIK | 415 | 0 | 415 | EUR |  |  |  | INTERCOMPANY
2 Months > | DRN005754 | 2020-07-27 00:00:00 | 1137 | Air Customs | YKYK | 250 | 0 | 250 | EUR |  |  |  | CASH CUSTOMER
1 Month | DRN005825 | 2020-09-15 00:00:00 | 1138 | Sea Export | HYJYK | 380 | 0 | 380 | EUR |  |  |  | FINANCIAL DIFFICULTIES
Current | DRN005856 | 2020-10-05 00:00:00 | 1139 | Air Export | CSCSC | 415 | 0 | 415 | EUR |  |  |  | CLOSED DOWN
Current | DRN005868 | 2020-10-14 00:00:00 | 1140 | Air Import | FWFW | 235 | 0 | 235 | EUR |  |  |  | MRA CUSTOMS
2 Mo+46:73nths > | DRN005728 | 2020-06-30 00:00:00 | 1141 | Air Import | FWFW | 33 | 0 | 33 | EUR |  |  |  | SMALL DIFFERENCES
2 Months > | [NAME] | 2020-07-11 00:00:00 | 1142 | Air Import | WFFW | 572.3 | 0 | 572.3 | EUR |  |  |  | DEPOSIT
2 Month | [NAME] | 2020-08-11 00:00:00 | 1143 | Air Import | RRR | 807.04 | 0 | 807.04 | EUR |  |  |  | LONG CREDIT BALANCE
1 Month | [NAME] | 2020-09-07 00:00:00 | 1144 | Air Import | FFWFW | 130.5 | 0 | 130.5 | EUR
1 Month | DRN005828 | 2020-09-18 00:00:00 | 1145 | Air Import | RR | 85.5 | 0 | 85.5 | EUR
Current | [NAME] | 2020-10-06 00:00:00 | 1146 | Air Import | WEWFGW | 201 | 0 | 201 | EUR
2 Months > | DRN005695 | 2020-05-21 00:00:00 | 1147 | Sea Import | FSFS | 1480 | 0 | 1480 | EUR
2 Months > | DRN004159 | 2018-05-22 00:00:00 | 1148 | Air Export | RRR | 1143 | 0 | 1143 | USD
Current | DRN005876 | 2020-10-19 00:00:00 | 1149 | Air Import | SFSDF | 237 | 0 | 237 | EUR
2 Month | DRN005771 | 2020-08-07 00:00:00 | 1150 | Air Customs | RRR | 986.6 | 0 | 986.6 | EUR
1 Month | DRN005820 | 2020-09-10 00:00:00 | 1151 | Air Export | ETWGTW | 2434.5 | 0 | 2434.5 | USD
1 Month | DRN005823 | 2020-09-14 00:00:00 | 1152 | Air Export | RRR | 54.9 | 0 | 54.9 | USD
1 Month | DRN005839 | 2020-09-25 00:00:00 | 1153 | Air Export | ETWGTW | 1006.8 | 0 | 1006.8 | USD
2 Months > | DRN005567 | 2020-02-05 00:00:00 | 1154 | Air Export | ETWGTW | 59950 | -59850 | 100 | MUR
2 Months > | DRN003553 | 2017-09-14 00:00:00 | 1155 | Sea Export | ETWGTW | 907.2 | 0 | 907.2 | USD
2 Months > | [NAME] | 2019-08-29 00:00:00 | 1156 | Air Import | ETWGTW | 293 | 0 | 293 | EUR
2 Months > | DRN005753 | 2020-07-23 00:00:00 | 1157 | Air Import | ETWGTW | 279.12 | 0 | 279.12 | EUR
2 Month | DRN005803 | 2020-08-31 00:00:00 | 1158 | Air Import | ETWGTW | 283.62 | 0 | 283.62 | EUR
2 Month | INV040331 | 2020-08-20 00:00:00 | 1159 | Profit share | ETWGTW | 9.45 | 0 | 9.45 | USD
2 Months > | DRN005496 | 2019-12-31 00:00:00 | 1160 | Air Import | ETWGTW | 180.96 | -172.9818 | 7.9782 | GBP
2 Months > | DRN004649 | 2019-01-04 00:00:00 | 1161 | Air Export | ETWGTW | 256 | 0 | 256 | USD
2 Months > | DRN004706 | 2019-01-25 00:00:00 | 1162 | Air Export | ETWGTW | 256 | 0 | 256 | USD
2 Months > | DRN004771 | 2019-02-20 00:00:00 | 1163 | Air Import | ETWGTW | 272 | 0 | 272 | USD
2 Months > | RCP097772 | 2020-02-26 00:00:00 | 1164 | Payment | ETWGTW |  | -48.01 | -48.01 | USD
2 Months > | MD001296 | 2018-04-26 00:00:00 | 1165 | Sea Import | ETWGTW | 247.08 | -238.67 | 8.41 | EUR
2 Month | DRN005808 | 2020-08-31 00:00:00 | 1166 | Air Import | ETWGTW | 375 | 0 | 375 | EUR
2 Months > | ALL023932 | 2019-07-11 00:00:00 | 1167 | Payment | ETWGTW |  | -248.23 | -248.23 | EUR
1 Month | ALL027110 | 2020-09-30 00:00:00 | 1168 | Payment | ETWGTW |  | -958.13 | -958.13 | USD
2 Month | INV040326 | 2020-08-20 00:00:00 | 1169 | Profit share | ETWGTW | 3895.1 | -2936.97 | 958.13 | USD
1 Month | ALL027104 | 2020-09-29 00:00:00 | 1170 | Payment | ETWGTW |  | -2664.63 | -2664.63 | EUR
1 Month | RCP105716 | 2020-09-07 00:00:00 | 1171 | Payment | ETWGTW |  | -1264.13 | -1264.13 | USD
2 Months > | DRN003854 | 2017-12-30 00:00:00 | 1172 | Air Export | ETWGTW | 230 | 0 | 230 | USD
2 Months > | RCP045604 | 2017-06-23 00:00:00 | 1173 | Payment | ETWGTW |  | -656.55 | -656.55 | EUR
2 Months > | DRN005255 | 2019-09-07 00:00:00 | 1174 | Sea Export | EEEEE | 35 | 0 | 35 | USD
2 Months > | DRN005256 | 2019-09-07 00:00:00 | 1175 | Sea Export | DFWDW | 30 | 0 | 30 | USD
2 Months > | DRN005272 | 2019-09-17 00:00:00 | 1176 | Sea Export | DD | 95 | 0 | 95 | USD
2 Months > | DRN005277 | 2019-09-17 00:00:00 | 1177 | Sea Export | ADAD | 50 | 0 | 50 | USD
2 Months > | DRN005285 | 2019-09-23 00:00:00 | 1178 | Sea Export | FFF | 95 | 0 | 95 | USD
2 Months > | DRN005304 | 2019-10-02 00:00:00 | 1179 | Sea Export | EWEW | 61 | -35.55 | 25.45 | USD
2 Months > | DRN005305 | 2019-10-02 00:00:00 | 1180 | Sea Export | FFFF | 65 | 0 | 65 | USD
2 Months > | DRN005317 | 2019-10-08 00:00:00 | 1181 | Sea Export | FFF | 65 | 0 | 65 | USD
2 Months > | DRN005318 | 2019-10-08 00:00:00 | 1182 | Sea Export | ERTYH | 65 | 0 | 65 | USD
2 Months > | MD001666 | 2019-10-15 00:00:00 | 1183 | Sea Export | WDRE | 65 | 0 | 65 | USD
2 Months > | MD001670 | 2019-10-19 00:00:00 | 1184 | Sea Export | JJJ | 65 | 0 | 65 | USD
2 Months > | MI003959 | 2019-10-29 00:00:00 | 1185 | Sea Export | DDDD | 45 | 0 | 45 | USD
2 Months > | MD001674 | 2019-10-30 00:00:00 | 1186 | Sea Export | DDDD | 65 | 0 | 65 | USD
2 Months > | MD001700 | 2019-11-26 00:00:00 | 1187 | Sea Export | FFF | 50 | 0 | 50 | USD
2 Months > | MD001722 | 2019-12-18 00:00:00 | 1188 | Sea Export | FF | 65 | 0 | 65 | USD