Spreadsheet: 864135d1711446720-how-to-sort-out-only-rows-with-values-based-on-certain-criteras-book-1
Sheet: Blad1

Date | Time | User | Machine | Operator | [NAME] | Prod # | Prod.Order | Sum | KI 1 | KI 2 | KI 3 | KI 4 | KI 5
2024-03-18 00:00:00 | 09:00:00 | Anders [NAME] | 5211 | 4513 | 123456 | 1 | A |  |  |  |  |  |  |  |  | How can I write a function that based on some criteras only ouputs the rows where I have values in KL 5
2024-03-18 00:00:00 | 11:16:14 | Produktion1 | 5212 | 4511 | 2110173 | 8 | 100 | 8
2024-03-20 00:00:00 | 09:55:01 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 9898 | 8 |  |  |  |  |  |  |  | Exemple:
2024-03-20 00:00:00 | 10:00:04 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338395 | 8
2024-03-20 00:00:00 | 11:05:19 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338395 | 16 |  |  |  |  |  |  |  | Choose Part number: |  |  | 2110173
2024-03-20 00:00:00 | 12:53:23 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338395 | 24 |  |  |  |  |  |  |  | From Date |  |  | 2024-03-21 00:00:00
2024-03-20 00:00:00 | 13:09:57 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338395 | 32 | OK |  |  |  |  |  |  | To date |  |  | 2024-03-25 00:00:00
2024-03-20 00:00:00 | 13:35:35 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338395 | 40 |  |  |  |  |  |  |  | Choose Column to find values in: |  |  | KL 5
2024-03-20 00:00:00 | 14:46:10 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338395 | 48
2024-03-20 00:00:00 | 14:46:12 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338395 | 56 |  |  |  |  |  |  |  | Result | Date | Time | Value
2024-03-20 00:00:00 | 14:46:14 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338395 | 64 | OK |  |  |  | 48.012 |  |  |  | 2024-03-20 00:00:00 | 14:46:14 | 48.012
2024-03-20 00:00:00 | 14:49:20 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 72 |  |  |  |  |  |  |  |  | 2024-03-20 00:00:00 | 18:13:54 | 48.02
2024-03-20 00:00:00 | 14:53:52 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 80 |  |  |  |  |  |  |  |  | 2024-03-21 00:00:00 | 01:22:14 | 48.016
2024-03-20 00:00:00 | 15:27:51 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 88 |  |  |  |  |  |  |  |  | 2024-03-21 00:00:00 | 05:03:15 | 48.015
2024-03-20 00:00:00 | 15:55:04 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 96 | OK |  |  |  |  |  |  |  | 2024-03-21 00:00:00 | 12:03:58 | 48.02
2024-03-20 00:00:00 | 16:26:37 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 104 |  |  |  |  |  |  |  |  | 2024-03-21 00:00:00 | 18:15:09 | 48.018
2024-03-20 00:00:00 | 16:48:51 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 112 |  |  |  |  |  |  |  |  | 2024-03-21 00:00:00 | 23:52:03 | 48.017
2024-03-20 00:00:00 | 17:34:09 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 120 |  | OK | OK |  |  |  |  |  | 2024-03-22 00:00:00 | 03:36:37 | 48.017
2024-03-20 00:00:00 | 18:13:54 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 128 | OK |  |  | OK | 48.02 |  |  |  | 2024-03-22 00:00:00 | 10:30:40 | 48.02
2024-03-20 00:00:00 | 19:35:21 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 136 |  |  |  |  |  |  |  |  | 2024-03-24 00:00:00 | 22:42:45 | 48.018
2024-03-20 00:00:00 | 21:14:41 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 144 |  |  |  |  |  |  |  |  | 2024-03-25 00:00:00 | 03:03:01 | 48.02
2024-03-20 00:00:00 | 21:17:55 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 152 |  |  |  |  |  |  |  |  | 2024-03-25 00:00:00 | 05:31:50 | 48.018
2024-03-20 00:00:00 | 21:48:56 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338395 | 160 | OK |  |  |  |  |  |  |  | 2024-03-25 00:00:00 | 09:31:25 | 48.006
2024-03-20 00:00:00 | 22:57:48 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 8 |  |  |  |  |  |  |  |  | 2024-03-25 00:00:00 | 14:55:38 | 48.005
2024-03-20 00:00:00 | 22:57:50 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 16 |  |  |  |  |  |  |  |  | 2024-03-25 00:00:00 | 22:29:59 | 48.01
2024-03-20 00:00:00 | 22:57:57 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 24 |  |  |  |  |  |  |  |  | 2024-03-26 00:00:00 | 02:51:31 | 48.013
2024-03-20 00:00:00 | 22:58:06 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 32 | OK |  |  |  |  |  |  |  | 2024-03-26 00:00:00 | 05:12:06 | 48.016
2024-03-20 00:00:00 | 23:57:55 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 40
2024-03-21 00:00:00 | 00:18:02 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 48
2024-03-21 00:00:00 | 00:56:12 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 56
2024-03-21 00:00:00 | 01:22:14 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 64 | OK |  |  |  | 48.016
2024-03-21 00:00:00 | 02:14:12 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 72
2024-03-21 00:00:00 | 02:40:11 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 80
2024-03-21 00:00:00 | 03:02:13 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 88
2024-03-21 00:00:00 | 03:23:59 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 96 | OK
2024-03-21 00:00:00 | 03:46:07 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 104
2024-03-21 00:00:00 | 04:08:11 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 112
2024-03-21 00:00:00 | 04:51:33 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 120 |  | OK | OK
2024-03-21 00:00:00 | 05:03:15 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 128 | OK |  |  | ok | 48.015
2024-03-21 00:00:00 | 07:30:12 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 136
2024-03-21 00:00:00 | 07:30:14 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 144
2024-03-21 00:00:00 | 07:55:25 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 152
2024-03-21 00:00:00 | 08:52:59 | Produktion1 | 5210 | 4531 | 30988982 | 3 | 789 | 0 | OK | OK | OK | OK | OK
2024-03-21 00:00:00 | 10:44:20 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 160 | OK
2024-03-21 00:00:00 | 10:44:24 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 168
2024-03-21 00:00:00 | 11:43:23 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 176
2024-03-21 00:00:00 | 11:43:24 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 184
2024-03-21 00:00:00 | 12:03:58 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 192 | OK |  |  |  | 48.02
2024-03-21 00:00:00 | 14:44:35 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 200
2024-03-21 00:00:00 | 15:21:26 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 208
2024-03-21 00:00:00 | 16:02:18 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 216
2024-03-21 00:00:00 | 16:25:28 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 224 | OK
2024-03-21 00:00:00 | 16:39:14 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 232
2024-03-21 00:00:00 | 17:35:24 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 240 |  | OK | OK
2024-03-21 00:00:00 | 17:35:31 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 248
2024-03-21 00:00:00 | 18:15:09 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 256 | OK |  |  | OK | 48.018
2024-03-21 00:00:00 | 18:21:59 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 264
2024-03-21 00:00:00 | 19:14:57 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 272
2024-03-21 00:00:00 | 19:14:58 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 280
2024-03-21 00:00:00 | 22:23:33 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 288 | OK
2024-03-21 00:00:00 | 22:23:37 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 296
2024-03-21 00:00:00 | 23:16:58 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 304
2024-03-21 00:00:00 | 23:26:39 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 312
2024-03-21 00:00:00 | 23:52:03 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 320 | OK |  |  |  | 48.017
2024-03-22 00:00:00 | 00:16:49 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 328
2024-03-22 00:00:00 | 01:12:19 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 336
2024-03-22 00:00:00 | 01:21:01 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 344
2024-03-22 00:00:00 | 02:40:54 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 352 | OK
2024-03-22 00:00:00 | 02:41:02 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 360 |  | OK | OK
2024-03-22 00:00:00 | 02:45:04 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 368
2024-03-22 00:00:00 | 02:57:40 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 376
2024-03-22 00:00:00 | 03:36:37 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 384 | OK |  |  | ok | 48.017
2024-03-22 00:00:00 | 03:37:48 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 392
2024-03-22 00:00:00 | 04:36:53 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 400
2024-03-22 00:00:00 | 04:37:38 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 408
2024-03-22 00:00:00 | 04:54:49 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 416 | OK
2024-03-22 00:00:00 | 05:05:20 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 424
2024-03-22 00:00:00 | 06:57:39 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 432
2024-03-22 00:00:00 | 06:57:39 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 440
2024-03-22 00:00:00 | 10:30:40 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 448 | OK |  |  |  | 48.02
2024-03-22 00:00:00 | 10:32:28 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 456
2024-03-22 00:00:00 | 10:36:47 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 464
2024-03-22 00:00:00 | 10:36:47 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 472
2024-03-22 00:00:00 | 10:36:48 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 480 | OK | OK | OK
2024-03-22 00:00:00 | 10:58:38 | Produktion1 | 5212 | 5591 | 2110173 | 8 | 338396 | 488
2024-03-24 00:00:00 | 22:01:15 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 496
2024-03-24 00:00:00 | 22:16:34 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 504
2024-03-24 00:00:00 | 22:42:45 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 512 | OK |  |  | ok | 48.018
2024-03-24 00:00:00 | 23:03:42 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 520
2024-03-24 00:00:00 | 23:41:37 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 528
2024-03-25 00:00:00 | 00:29:34 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 536
2024-03-25 00:00:00 | 00:55:26 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 544 | OK
2024-03-25 00:00:00 | 00:55:35 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 552
2024-03-25 00:00:00 | 01:32:10 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 560
2024-03-25 00:00:00 | 02:30:47 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 568
2024-03-25 00:00:00 | 03:03:01 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 576 | OK |  |  |  | 48.02
2024-03-25 00:00:00 | 03:04:09 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 584
2024-03-25 00:00:00 | 03:19:39 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 592
2024-03-25 00:00:00 | 03:38:07 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 600 |  | OK | OK
2024-03-25 00:00:00 | 04:02:24 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 608 | OK
2024-03-25 00:00:00 | 04:44:44 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 616
2024-03-25 00:00:00 | 04:45:43 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 624
2024-03-25 00:00:00 | 05:31:49 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 632
2024-03-25 00:00:00 | 05:31:50 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 640 | OK |  |  | ok | 48.018
2024-03-25 00:00:00 | 05:42:08 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 648
2024-03-25 00:00:00 | 06:32:47 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 656
2024-03-25 00:00:00 | 07:13:18 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 664
2024-03-25 00:00:00 | 07:40:31 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 672 | OK
2024-03-25 00:00:00 | 08:37:33 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 680
2024-03-25 00:00:00 | 08:42:11 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 688
2024-03-25 00:00:00 | 09:31:23 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 696
2024-03-25 00:00:00 | 09:31:25 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 704 | OK |  |  |  | 48.006
2024-03-25 00:00:00 | 10:43:54 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 712
2024-03-25 00:00:00 | 10:43:55 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 720 |  | OK | OK
2024-03-25 00:00:00 | 11:56:30 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 728
2024-03-25 00:00:00 | 11:56:31 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 736 | OK
2024-03-25 00:00:00 | 13:21:50 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 744
2024-03-25 00:00:00 | 13:21:51 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 752
2024-03-25 00:00:00 | 13:49:53 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 760
2024-03-25 00:00:00 | 14:55:38 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 768 | OK |  |  | ok | 48.005
2024-03-25 00:00:00 | 17:09:10 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 776
2024-03-25 00:00:00 | 22:29:51 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 784
2024-03-25 00:00:00 | 22:29:52 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 792
2024-03-25 00:00:00 | 22:29:52 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 800 | OK
2024-03-25 00:00:00 | 22:29:56 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 808
2024-03-25 00:00:00 | 22:29:56 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 816
2024-03-25 00:00:00 | 22:29:57 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 824
2024-03-25 00:00:00 | 22:29:59 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 832 | OK |  |  |  | 48.01
2024-03-25 00:00:00 | 23:16:28 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 840 |  | OK | OK
2024-03-25 00:00:00 | 23:26:14 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 848
2024-03-26 00:00:00 | 00:02:35 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 856
2024-03-26 00:00:00 | 00:38:55 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 864 | OK
2024-03-26 00:00:00 | 00:58:20 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 872
2024-03-26 00:00:00 | 01:17:24 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 880
2024-03-26 00:00:00 | 01:48:34 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 888
2024-03-26 00:00:00 | 02:51:31 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 896 | OK |  |  | ok | 48.013
2024-03-26 00:00:00 | 02:52:12 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 904
2024-03-26 00:00:00 | 03:41:54 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 912
2024-03-26 00:00:00 | 03:41:55 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 920
2024-03-26 00:00:00 | 03:42:20 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 928 | OK
2024-03-26 00:00:00 | 04:20:02 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 936
2024-03-26 00:00:00 | 04:20:03 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 944
2024-03-26 00:00:00 | 05:04:35 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 952
2024-03-26 00:00:00 | 05:12:06 | Produktion1 | 5212 | 5554 | 2110173 | 8 | 338396 | 960 | OK | OK | ok |  | 48.016
2024-03-26 00:00:00 | 05:55:53 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 968
2024-03-26 00:00:00 | 05:55:54 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 976
2024-03-26 00:00:00 | 07:00:00 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 984
2024-03-26 00:00:00 | 07:24:01 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 992 | OK
2024-03-26 00:00:00 | 07:36:26 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 1000
2024-03-26 00:00:00 | 08:40:20 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 1008
2024-03-26 00:00:00 | 08:50:30 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 1016
2024-03-26 00:00:00 | 10:32:59 | Produktion1 | 5212 | 5521 | 2110173 | 8 | 338396 | 1024