Spreadsheet: 688989d1596051935-using-min-max-and-countif-on-ranges-populated-by-formulas-tracer-example-minifs-with-data-and-formulas-change-from-text-to-number
Sheet: Raw Data

CARTON | LOT | [NAME] | PACK DATE | PACK TIME
0159881 | 7201D | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-10 00:00:00 | 16:21:17
0159882 | 7201D | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-10 00:00:00 | 16:21:21
0159883 | 7201D | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-10 00:00:00 | 16:21:24
0159884 | 7201D | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-10 00:00:00 | 16:24:23
0159885 | 7201D | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-10 00:00:00 | 16:26:08
0159886 | 7201D | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-10 00:00:00 | 16:26:16
0159887 | 7201D | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-10 00:00:00 | 16:29:46
0159888 | 7201D | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-10 00:00:00 | 16:29:50
0159889 | 7201D | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-10 00:00:00 | 16:31:08
0159890 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:08:15
0159891 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:08:24
0159892 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:08:28
0159893 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:08:33
0159894 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:12:25
0159895 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:12:30
0159896 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:12:34
0159897 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | [NAME]
0159898 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:18:46
0159899 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:18:51
0159900 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:23:18
0159901 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:23:23
0159902 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:24:02
0159903 | 7201A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:24:08
0159904 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:33:47
0159905 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:33:51
0159906 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:33:55
0159907 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:34:02
0159908 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:34:08
0159909 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:36:27
0159910 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:36:31
0159911 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:36:34
0159912 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:36:38
0159913 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:36:42
0159914 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:49:53
0159915 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:50:08
0159916 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:53:09
0159917 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 08:53:13
0159918 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:04:00
0159919 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:04:04
0159920 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:04:07
0159921 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:04:12
0159922 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:04:15
0159923 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:04:19
0159924 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:17:36
0159925 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:17:40
0159926 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:17:43
0159927 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:17:45
0159928 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:24:12
0159929 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:24:15
0159930 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:29:21
0159931 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:29:23
0159932 | 7190A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:32:40
0159933 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | [NAME]
0159934 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:34:41
0159935 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:39:31
0159936 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:39:37
0159937 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:39:39
0159938 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:39:40
0159939 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:39:44
0159940 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:39:46
0159941 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:39:48
0159942 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:39:49
0159943 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:39:52
0159944 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | [NAME]
0159945 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | [NAME]
0159946 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:45:35
0159947 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:45:38
0159948 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:45:42
0159949 | 7200A | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 09:45:45
0159950 | 7200B | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 10:23:40
0159951 | 7200B | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 10:23:45
0159952 | 7200B | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 10:23:48
0159953 | 7200B | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 10:23:52
0159954 | 7200B | COHO SALMON FROZEN VP PAVE 145 GRAM ECP 10 KG CARTON | 2018-01-11 00:00:00 | 10:29:44