Spreadsheet: 705146d1605887786-conditional-formatting-max-value-per-row-with-criteria-order_location_sample
Sheet: Sheet1

OrderNo | BillToName | Current Location | Pull Active | PCB Cell | [NAME] | Production Staging | Assembly Staging | Assembly 1 Cell | Assembly 2 Cell | Assembly 3 Cell | Assembly 4 Cell | Assembly 5 Cell | First Article | Final Test Queue | Final Test 1 | Final Assembly Cell | Shipping Department
2202516 | Company Name | Final Test Queue | 2020-07-20 08:24:43 | 2020-07-21 13:02:59 | 2020-07-22 10:52:05 |  | 2020-07-22 11:38:08 |  |  |  |  |  |  | 2020-08-25 14:05:17
2202518 | Company Name | Final Test Queue | 2020-07-20 08:24:59 | 2020-07-21 11:15:00 | 2020-07-22 10:18:55 |  | 2020-07-22 11:23:53 |  |  |  |  |  |  | 2020-08-25 15:25:43
2203583 | Company Name | Production Staging | 2020-10-12 08:02:52 |  |  | 2020-11-17 08:41:09 |  |  |  | 2020-10-13 13:31:52 |  |  |  | 2020-10-20 10:27:50 | 2020-10-20 10:31:54 | 2020-10-20 15:38:28 | 2020-10-21 10:29:47
2203607 | Company Name | PCB Cell | 2020-11-20 08:49:23 | 2020-11-20 10:15:29
2203705 | Company Name | Final Test Queue | 2020-11-13 13:49:39 | 2020-11-13 14:36:25 | 2020-11-13 14:55:34 |  | 2020-11-13 15:20:41 |  | 2020-11-13 16:00:21 |  |  |  |  | 2020-11-13 16:22:12
2203733 | Company Name | Final Assembly Cell | 2020-11-17 08:43:33 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-17 09:20:17
2203749 | Company Name | Final Assembly Cell | 2020-11-09 08:03:32 | 2020-11-09 09:07:47 | 2020-11-09 10:34:37 |  | 2020-11-09 12:59:13 |  | 2020-11-09 15:29:59 |  |  |  |  | 2020-11-19 10:48:38 |  | 2020-11-19 10:55:55
2203768 | Company Name | Final Assembly Cell | 2020-11-03 08:00:09 | 2020-11-03 13:44:02 | 2020-11-04 13:51:16 | 2020-11-05 10:59:31 |  | 2020-11-05 11:06:53 |  |  |  |  |  | 2020-11-16 15:27:26 | 2020-11-17 07:38:04 | 2020-11-17 08:25:24
2203769 | Company Name | Final Assembly Cell | 2020-11-03 07:59:41 | 2020-11-03 13:44:21 | 2020-11-04 14:19:19 | 2020-11-05 13:26:42 |  |  |  |  |  |  |  | 2020-11-16 09:45:24 | 2020-11-16 13:01:07 | 2020-11-16 14:16:02
2203770 | Company Name | Final Test Queue | 2020-11-03 07:59:51 | 2020-11-03 13:43:39 | 2020-11-04 14:03:24 | 2020-11-04 16:18:48 |  |  |  |  |  |  |  | 2020-11-19 14:40:42
2203805 | Company Name | Shipping Department | 2020-11-06 13:45:03 | 2020-11-06 16:14:12 | 2020-11-09 10:30:00 |  | 2020-11-09 11:18:20 |  | 2020-11-09 13:54:41 |  |  |  |  | 2020-11-09 14:10:38 | 2020-11-18 08:55:09 | 2020-11-18 09:49:15 | 2020-11-20 09:13:34
2203822 | Company Name | Final Test 1 | 2020-11-19 08:11:16 | 2020-11-19 09:03:04 | 2020-11-19 09:34:15 |  |  |  |  |  |  |  |  |  | 2020-11-19 09:58:49
2203834 | Company Name | Production Staging | 2020-11-02 12:23:31 | 2020-11-02 14:26:23 | 2020-11-04 10:23:46 | 2020-11-04 10:44:49
2203840 | Company Name | Final Test Queue | 2020-11-13 13:50:44 |  | 2020-11-16 10:18:17 | 2020-11-16 13:50:27 |  |  |  |  |  |  |  | 2020-11-19 16:02:48
2203841 | Company Name | Final Test Queue | 2020-11-13 13:50:32 | 2020-11-13 14:50:48 | 2020-11-13 15:26:59 |  | 2020-11-13 15:58:51 |  | 2020-11-16 08:08:28 |  |  |  |  | 2020-11-16 09:58:29
2203844 | Company Name | Final Assembly Cell | 2020-11-17 08:42:59 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-17 09:10:59
2203851 | Company Name | Final Assembly Cell | 2020-11-12 08:09:50 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-19 10:37:49
2203855 | Company Name | Production Staging | 2020-11-09 08:04:08 | 2020-11-09 11:58:49 | 2020-11-10 09:54:33 | 2020-11-11 10:49:17
2203880 | Company Name | Final Test Queue | 2020-11-13 13:50:53 | 2020-11-16 13:48:09 |  |  | 2020-11-16 16:05:55 |  |  |  |  |  |  | 2020-11-19 10:43:42
2203889 | Company Name | Pull Active | 2020-11-20 08:51:23
2203893 | Company Name | Pull Active | 2020-11-20 08:50:01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-12 09:15:38
2203894 | Company Name | Pull Active | 2020-11-20 08:49:43
2203897 | Company Name | Assembly Staging | 2020-11-18 08:51:11 | 2020-11-18 11:42:27 | 2020-11-18 11:47:03 |  | 2020-11-18 13:04:11
2203902 | Company Name | Final Test Queue | 2020-11-11 08:10:10 | 2020-11-11 11:27:42 | 2020-11-12 11:15:27 |  | 2020-11-12 13:09:51 |  |  |  | 2020-11-18 11:19:35 |  |  | 2020-11-18 15:13:05
2203928 | Company Name | Assembly Staging | 2020-11-17 09:23:14 | 2020-11-17 11:53:01 | 2020-11-18 08:24:50 |  | 2020-11-18 10:17:29
2203929 | Company Name | Production Staging | 2020-11-17 09:23:04 | 2020-11-17 12:42:12 | 2020-11-18 08:29:02 | 2020-11-18 09:06:40
2203936 | Company Name | Final Assembly Cell | 2020-11-17 08:42:49 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-17 09:10:24
2203937 | Company Name | Shipping Department | 2020-11-10 09:17:07 | 2020-11-10 11:46:22 | 2020-11-10 14:03:42 |  | 2020-11-11 16:22:35 |  |  |  | 2020-11-12 10:00:16 |  |  | 2020-11-19 11:16:11 |  | 2020-11-19 11:46:32 | 2020-11-20 09:18:12
2203938 | Company Name | Final Assembly Cell | 2020-11-10 09:16:58 | 2020-11-11 11:57:35 |  |  | 2020-11-12 08:29:28 | 2020-11-12 11:37:48 |  |  |  |  |  | 2020-11-19 10:21:29 |  | 2020-11-19 10:50:20
2203940 | Company Name | Shipping Department | 2020-11-10 09:16:38 | 2020-11-10 11:45:41 | 2020-11-10 14:02:17 |  |  |  |  |  |  |  |  | 2020-11-19 11:01:53 | 2020-11-12 08:39:04 | 2020-11-19 11:13:07 | 2020-11-20 08:49:26
2203941 | Company Name | Final Assembly Cell | 2020-11-10 09:16:29 | 2020-11-11 13:04:28 |  | 2020-11-12 10:42:04 |  |  |  | 2020-11-12 13:42:54 |  |  |  | 2020-11-16 16:15:04 | 2020-11-19 08:54:30 | 2020-11-19 10:15:00
2203943 | Company Name | Final Test Queue | 2020-11-17 09:22:15 |  |  |  |  |  |  |  |  |  |  | 2020-11-19 09:55:39
2203944 | Company Name | Final Test Queue | 2020-11-17 09:22:23 |  |  |  |  |  |  |  |  |  |  | 2020-11-19 09:55:46
2203945 | Company Name | Final Test Queue | 2020-11-17 09:22:33 |  |  |  |  |  |  |  |  |  |  | 2020-11-19 09:56:05
2203946 | Company Name | Final Test Queue | 2020-11-17 09:22:43 |  |  |  |  |  |  |  |  |  |  | 2020-11-19 09:55:53
2203947 | Company Name | Final Test Queue | 2020-11-17 09:22:54 |  |  |  |  |  |  |  |  |  |  | 2020-11-19 09:55:59
2203948 | Company Name | Final Assembly Cell | 2020-11-10 11:33:03 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-10 14:03:07
2203949 | Company Name | Shipping Department | 2020-11-10 11:40:30 | 2020-11-11 11:46:15 |  |  | 2020-11-12 13:05:54 |  |  |  |  |  |  | 2020-11-19 11:55:08 |  | 2020-11-19 13:33:57 | 2020-11-20 09:22:05
2203957 | Company Name | Final Assembly Cell | 2020-11-13 07:59:42 | 2020-11-13 09:23:21 | 2020-11-13 10:30:46 |  |  |  |  |  |  |  |  |  | 2020-11-18 12:41:56 | 2020-11-18 13:37:57
2203958 | Company Name | Final Test Queue | 2020-11-10 11:40:51 | 2020-11-11 11:41:58 |  |  | 2020-11-12 13:31:25 |  |  |  |  |  |  | 2020-11-12 14:45:50
2203962 | Company Name | Final Assembly Cell | 2020-11-10 11:29:36 | 2020-11-11 11:39:00 |  |  |  |  | 2020-11-12 10:47:49 |  |  |  | 2020-11-12 10:47:22 | 2020-11-20 08:13:20 |  | 2020-11-20 08:26:29
2203967 | Company Name | Final Assembly Cell | 2020-11-10 15:12:49 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-19 10:16:12
2203968 | Company Name | Assembly 5 Cell | 2020-11-10 15:11:54 |  |  |  |  |  |  |  |  | 2020-11-19 11:45:22
2203973 | Company Name | Final Assembly Cell | 2020-11-11 08:50:40 | 2020-11-11 11:27:19 | 2020-11-12 10:29:17 |  |  |  |  |  |  |  |  | 2020-11-19 14:00:43 | 2020-11-12 11:39:31 | 2020-11-19 14:27:14
2203976 | Company Name | Final Assembly Cell | 2020-11-11 08:50:47 | 2020-11-11 11:26:25 | 2020-11-12 11:13:34 |  | 2020-11-12 11:58:14 |  | 2020-11-12 13:12:29 |  |  |  |  | 2020-11-20 08:21:31 |  | 2020-11-20 08:26:41
2203978 | Company Name | Final Assembly Cell | 2020-11-11 08:50:56 | 2020-11-11 11:26:49 | 2020-11-12 10:59:34 |  | 2020-11-12 14:12:53 |  | 2020-11-12 14:57:28 |  |  |  |  | 2020-11-20 08:00:18 |  | 2020-11-20 08:09:38
2203979 | Company Name | Production Staging | 2020-11-11 08:51:04 | 2020-11-11 11:28:12 | 2020-11-12 10:56:34 | 2020-11-12 11:46:38
2203982 | Company Name | Shipping Department | 2020-11-11 13:05:23 | 2020-11-11 13:18:50 | 2020-11-12 10:26:52 | 2020-11-12 10:56:52 |  |  | 2020-11-13 15:42:21 |  |  |  |  | 2020-11-13 15:46:08 | 2020-11-18 08:37:34 | 2020-11-18 08:46:14 | 2020-11-20 09:04:12
2203986 | Company Name | Production Staging | 2020-11-16 16:25:48 | 2020-11-17 09:12:24 | 2020-11-17 09:37:08 | 2020-11-18 09:56:22
2203996 | Company Name | Final Test Queue | 2020-11-18 08:51:01 | 2020-11-18 11:01:15 | 2020-11-18 11:06:25 |  | 2020-11-18 11:22:17 |  |  |  |  |  | 2020-11-19 16:18:50 | 2020-11-19 16:24:40
2203998 | Company Name | Final Test Queue | 2020-11-18 08:49:45 | 2020-11-18 09:44:32 | 2020-11-18 09:51:42 |  | 2020-11-18 10:29:02 |  | 2020-11-20 08:53:41 |  |  |  |  | 2020-11-20 09:44:57
2203999 | Company Name | Final Assembly Cell | 2020-11-13 13:51:09 | 2020-11-13 14:39:11 | 2020-11-13 14:57:53 |  | 2020-11-16 08:31:30 |  |  |  |  |  |  | 2020-11-16 13:09:51 |  | 2020-11-17 10:18:26
2204002 | Company Name | Final Assembly Cell | 2020-11-12 15:18:41 | 2020-11-13 09:30:09 | 2020-11-13 10:37:15 |  | 2020-11-13 10:57:21 |  | 2020-11-13 13:40:30 |  |  |  |  | 2020-11-20 07:54:34 |  | 2020-11-20 08:04:04
2204008 | Company Name | Assembly 5 Cell | 2020-11-18 08:50:11 |  |  |  |  |  |  |  |  | 2020-11-19 11:44:54
2204010 | Company Name | Final Test Queue | 2020-11-18 11:32:21 | 2020-11-18 13:05:22 | 2020-11-18 13:20:09 |  | 2020-11-18 14:05:47 | 2020-11-18 16:12:39 |  |  |  |  |  | 2020-11-20 09:20:32
2204011 | Company Name | Final Test Queue | 2020-11-13 13:49:06 | 2020-11-16 08:57:56 |  | 2020-11-16 10:58:24 |  | 2020-11-17 13:15:27 |  |  |  |  |  | 2020-11-17 14:14:36
2204012 | Company Name | Final Test Queue | 2020-11-13 13:41:28 | 2020-11-16 08:58:25 | 2020-11-16 08:58:18 | 2020-11-16 09:58:42 |  | 2020-11-17 14:17:46 |  |  |  |  |  | 2020-11-17 15:44:23
2204015 | Company Name | Final Test 1 | 2020-11-13 15:43:09 | 2020-11-13 15:52:01 | 2020-11-16 08:47:06 |  |  |  |  |  |  |  |  |  | 2020-11-16 09:30:45
2204025 | Company Name | Final Test 1 | 2020-11-16 07:59:53 | 2020-11-16 08:38:52 | 2020-11-16 09:03:50 |  |  |  |  |  |  |  |  |  | 2020-11-16 09:45:04
2204027 | Company Name | Production Staging | 2020-11-18 11:32:32 | 2020-11-18 13:40:54 | 2020-11-18 13:48:04 | 2020-11-18 14:29:13
2204029 | Company Name | Assembly Staging | 2020-11-16 07:59:44 | 2020-11-16 08:36:56 | 2020-11-16 13:09:24 |  | 2020-11-18 14:55:29
2204034 | Company Name | Final Test 1 | 2020-11-18 08:50:42 | 2020-11-18 10:37:13 | 2020-11-18 10:45:07 |  |  |  |  |  |  |  |  |  | 2020-11-18 11:39:09
2204036 | Company Name | Pull Active | 2020-11-20 08:51:08
2204037 | Company Name | Pull Active | 2020-11-20 08:50:57
2204039 | Company Name | Final Test Queue | 2020-11-16 16:24:57 | 2020-11-17 09:12:07 | 2020-11-17 09:31:26 | 2020-11-18 09:14:17 |  |  | 2020-11-19 14:22:36 |  |  |  |  | 2020-11-19 14:22:45
2204040 | Company Name | Final Test Queue | 2020-11-16 16:25:06 |  |  |  |  |  |  |  | 2020-11-19 08:27:44 |  |  | 2020-11-19 09:56:16
2204041 | Company Name | Assembly Staging | 2020-11-16 16:25:35 | 2020-11-18 08:59:05 | 2020-11-18 09:08:25 |  | 2020-11-18 09:36:19
2204042 | Company Name | Final Test Queue | 2020-11-18 08:50:01 | 2020-11-18 09:41:23 | 2020-11-18 09:49:21 |  | 2020-11-18 10:21:31 |  | 2020-11-20 08:09:29 |  |  |  |  | 2020-11-20 08:30:15
2204044 | Company Name | Production Staging | 2020-11-17 09:21:33 |  |  | 2020-11-19 14:35:00
2204047 | Company Name | [NAME] | 2020-11-18 08:49:54 | 2020-11-18 10:58:25 | 2020-11-18 11:06:16
2204050 | Company Name | Assembly 5 Cell | 2020-11-19 08:02:19 |  |  |  |  |  |  |  |  | 2020-11-19 11:44:44
2204053 | Company Name | Final Test Queue | 2020-11-19 08:02:10 | 2020-11-19 08:54:30 | 2020-11-19 09:24:39 | 2020-11-19 09:46:12 |  |  |  |  |  |  | 2020-11-19 14:27:51 | 2020-11-19 15:21:19
2204057 | Company Name | Final Test Queue | 2020-11-19 08:01:59 | 2020-11-19 08:51:53 | 2020-11-19 09:21:01 |  | 2020-11-19 09:35:26 |  | 2020-11-19 15:27:47 |  |  |  |  | 2020-11-19 16:16:02
2204072 | Company Name | Production Staging | 2020-11-19 08:12:26 |  |  | 2020-11-19 09:29:12
2204073 | Company Name | Assembly 1 Cell | 2020-11-19 08:02:44 | 2020-11-19 11:21:52 | 2020-11-19 11:24:34 |  | 2020-11-19 11:36:50 | 2020-11-20 09:27:07
2204074 | Company Name | Final Test 1 | 2020-11-19 08:02:55 | 2020-11-19 09:07:27 | 2020-11-19 09:37:24 |  |  |  |  |  |  |  |  |  | 2020-11-19 10:26:04
2204078 | Company Name | Assembly Staging | 2020-11-19 08:03:03 | 2020-11-19 09:10:33 | 2020-11-19 09:41:15 |  | 2020-11-19 09:50:32
2204081 | Company Name | Assembly Staging | 2020-11-19 10:57:28 | 2020-11-19 13:35:49 | 2020-11-19 13:39:46 |  | 2020-11-19 14:53:26
2204084 | Company Name | [NAME] | 2020-11-19 10:55:41 | 2020-11-19 13:02:27 | 2020-11-20 09:00:34
2204092 | Company Name | PCB Cell | 2020-11-20 08:02:27 | 2020-11-20 08:37:37
2204099 | Company Name | PCB Cell | 2020-11-20 08:02:40 | 2020-11-20 08:42:56
2204108 | Company Name | Pull Active | 2020-11-20 09:49:06
2204109 | Company Name | Pull Active | 2020-11-20 09:54:11