Spreadsheet: 780241d1652356480-remove-cancelled-transactions-from-filter-output-filterb
Sheet: Sheet1

CAR | ACCOUNT DATE | TOLL GATE ENTRY | TOLL GATE EXIT | REFERENCE DATE | ENTERED TOLL GATE | EXITED TOLL GATE | COMMENTS | A/B | AMOUNT
34DZF150 | 2022-03-14 21:09:05 | 2022-03-13 16:50:32 | 2022-03-13 16:52:20 | 2022-03-13 16:52:20 | FENERTEPE | IŞIKLAR |  | B | 13
34DZF150 | 2022-03-16 21:11:48 | 2022-03-13 18:01:53 | 2022-03-13 18:04:19 | 2022-03-13 18:04:19 | IŞIKLAR | FENERTEPE |  | B | 13
34DZF150 | 2022-03-17 21:08:51 | 2022-03-16 12:12:19 | 2022-03-16 12:12:19 | 2022-03-16 12:12:19 | İKİTELLİ | İKİTELLİ |  | B | 86
34DZF150 | 2022-03-17 21:09:17 | 2022-03-16 15:22:27 | 2022-03-16 15:22:27 | 2022-03-16 15:22:27 | CEBECI (GÜNEY) | CEBECI (GÜNEY) |  | B | 1.5
34DZF150 | 2022-03-17 21:08:25 | 2022-03-16 15:23:17 | 2022-03-16 15:23:17 | 2022-03-16 15:23:17 | HASDAL | HASDAL |  | B | 6.5
34DZF150 | 2022-03-19 21:11:21 | 1901-01-01 01:01:01 | 2022-03-18 19:04:29 | 2022-03-18 19:04:29 |  | ODAYERİ |  | A | 86
34DZF150 | 2022-03-19 21:11:27 | 1901-01-01 01:01:01 | 2022-03-18 19:04:29 | 2022-03-18 19:04:29 |  | ODAYERİ |  | B | 86
34DZF150 | 2022-03-30 21:11:53 | 1901-01-01 01:01:01 | 2022-03-18 19:04:29 | 2022-03-18 19:04:29 | FENERTEPE | ODAYERİ |  | B | 15.5
34DZF150 | 2022-03-19 21:11:18 | 2022-03-18 19:06:29 | 2022-03-18 19:06:29 | 2022-03-18 19:06:29 | KARGO | KARGO |  | B | 2
34DZF150 | 2022-03-24 21:11:45 | 2022-03-18 19:08:39 | 2022-03-18 19:08:39 | 2022-03-18 19:08:39 | TERMINAL 1 YANYOL | TERMINAL 1 YANYOL |  | B | 1.5
34DZF150 | 2022-03-19 21:11:31 | 2022-03-18 19:09:26 | 2022-03-18 19:09:26 | 2022-03-18 19:09:26 | TERMINAL 2 YANYOL | TERMINAL 2 YANYOL |  | B | 1.5
34DZF150 | 2022-03-23 21:12:11 | 2022-03-18 19:17:39 | 2022-03-18 19:17:39 | 2022-03-18 19:17:39 | TERMINAL 2 YANYOL | TERMINAL 2 YANYOL |  | B | 2
34DZF150 | 2022-03-19 21:11:18 | 2022-03-18 19:18:26 | 2022-03-18 19:18:26 | 2022-03-18 19:18:26 | TERMINAL 1 YANYOL | TERMINAL 1 YANYOL |  | B | 2
34DZF150 | 2022-03-19 21:11:31 | 2022-03-18 19:20:33 | 2022-03-18 19:20:33 | 2022-03-18 19:20:33 | KARGO | KARGO |  | B | 2
34DZF150 | 2022-03-19 21:11:12 | 2022-03-18 18:59:50 | 2022-03-18 19:26:06 | 2022-03-18 19:26:06 | FENERTEPE | FENERTEPE |  | A | 96.5
34DZF150 | 2022-03-19 21:11:20 | 2022-03-18 18:59:50 | 2022-03-18 19:26:06 | 2022-03-18 19:26:06 | FENERTEPE | FENERTEPE |  | B | 96.5
34DZF150 | 2022-03-23 21:10:50 | 2022-03-18 18:59:50 | 2022-03-18 19:26:06 | 2022-03-18 19:26:06 | IŞIKLAR | FENERTEPE |  | B | 13
34DZF150 | 2022-03-31 21:12:50 | 2022-03-29 10:01:27 | 2022-03-29 10:03:14 | 2022-03-29 10:03:14 | FENERTEPE | IŞIKLAR |  | B | 13
34DZF150 | 2022-03-31 21:12:53 | 2022-03-29 12:03:33 | 2022-03-29 12:05:33 | 2022-03-29 12:05:33 | IŞIKLAR | FENERTEPE |  | B | 96.5
34DZF150 | 2022-04-02 21:10:39 | 2022-03-30 00:48:44 | 2022-03-30 00:53:58 | 2022-03-30 00:53:58 | ISPARTAKULE | MAHMUTBEY |  | B | 6.5
 | As you can see in "Column I", the toll account transactions of cars is coded A and B. "B" are the passes that has occurred. But every once in a while these toll passes can be cancelled for whatever reason. When this happens, instead of removing the row, system adds a 2nd row with the same amount, and codes it "A". Therefore I need to find a way to tell my FILTER to remove the B's that are cancelled.  In other words, the yellow colored rows must not be in the output.  Below is my current formula, that is filtering only the A's. Whether you improve it or write anew is your prerogative :)
 |  |  |  |  |  |  |  |  |  | PLATE NO | PICK UP | DROP OFF
 |  |  |  |  |  |  |  |  |  | 34DZF150 | 2022-03-15 17:35:43 | 2022-03-22 15:25:54
CAR | ACCOUNT DATE | TOLL GATE ENTRY | TOLL GATE EXIT | REFERENCE DATE | ENTERED TOLL GATE | EXITED TOLL GATE | COMMENTS | A/B | AMOUNT
 | 2022-03-17 21:08:51 | 2022-03-16 12:12:19 | 2022-03-16 12:12:19 | 2022-03-16 12:12:19 | İKİTELLİ | İKİTELLİ |  | B | 86
34DZF150 | 2022-03-17 21:09:17 | 2022-03-16 15:22:27 | 2022-03-16 15:22:27 | 2022-03-16 15:22:27 | CEBECI (GÜNEY) | CEBECI (GÜNEY) |  | B | 1.5
34DZF150 | 2022-03-17 21:08:25 | 2022-03-16 15:23:17 | 2022-03-16 15:23:17 | 2022-03-16 15:23:17 | HASDAL | HASDAL |  | B | 6.5
34DZF150 | 2022-03-30 21:11:53 | 1901-01-01 01:01:01 | 2022-03-18 19:04:29 | 2022-03-18 19:04:29 | FENERTEPE | ODAYERİ |  | B | 15.5
34DZF150 | 2022-03-19 21:11:18 | 2022-03-18 19:06:29 | 2022-03-18 19:06:29 | 2022-03-18 19:06:29 | KARGO | KARGO |  | B | 2
34DZF150 | 2022-03-24 21:11:45 | 2022-03-18 19:08:39 | 2022-03-18 19:08:39 | 2022-03-18 19:08:39 | TERMINAL 1 YANYOL | TERMINAL 1 YANYOL |  | B | 1.5
34DZF150 | 2022-03-19 21:11:31 | 2022-03-18 19:09:26 | 2022-03-18 19:09:26 | 2022-03-18 19:09:26 | TERMINAL 2 YANYOL | TERMINAL 2 YANYOL |  | B | 1.5
34DZF150 | 2022-03-23 21:12:11 | 2022-03-18 19:17:39 | 2022-03-18 19:17:39 | 2022-03-18 19:17:39 | TERMINAL 2 YANYOL | TERMINAL 2 YANYOL |  | B | 2
34DZF150 | 2022-03-19 21:11:18 | 2022-03-18 19:18:26 | 2022-03-18 19:18:26 | 2022-03-18 19:18:26 | TERMINAL 1 YANYOL | TERMINAL 1 YANYOL |  | B | 2
34DZF150 | 2022-03-19 21:11:31 | 2022-03-18 19:20:33 | 2022-03-18 19:20:33 | 2022-03-18 19:20:33 | KARGO | KARGO |  | B | 2
34DZF150 | 2022-03-23 21:10:50 | 2022-03-18 18:59:50 | 2022-03-18 19:26:06 | 2022-03-18 19:26:06 | IŞIKLAR | FENERTEPE |  | B | 13