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: Result

VANID | GESU9387127
Cartons | Carton # | Source 1 | Trunc 1 | Source 2 | Trunc 2 | Source 3 | Trunc 3 | Source 4 | Trunc 4 | Source 5 | Trunc 5 | Source 6 | Trunc 6 | Original Carton # | Source Lot | [NAME] | PKGTYPE | PACKDATE | PACKTIME | PD&T
1022393 | 1022393 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 11:55:08
1022394 | 1022394 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 11:55:29
1022395 | 1022395 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 11:55:47
1022396 | 1022396 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 11:57:30
1022397 | 1022397 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 13:01:48
1022398 | 1022398 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 13:06:00
1022399 | 1022399 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 13:06:31
1022400 | 1022400 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 13:07:14
1022401 | 1022401 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 13:12:50
1022402 | 1022402 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 13:18:15
1022403 | 1022403 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 13:19:57
1022404 | 1022404 | R:5010377 | 5010377 | R:5006069 | 5006069 | R:5001910 | 5001910 |  |  |  |  |  |  |  | 9223 | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-06-12 00:00:00 | 13:23:16
3018764 | 3018764 | R:5010664 | 5010664 | R:5010656 | 5010656 |  |  |  |  |  |  |  |  |  | 0178A | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-07-16 00:00:00 | 12:35:55
3018766 | 3018766 | R:5010664 | 5010664 | R:5010656 | 5010656 |  |  |  |  |  |  |  |  |  | 0178A | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-07-16 00:00:00 | 13:03:09
3018767 | 3018767 | R:5010664 | 5010664 | R:5010656 | 5010656 |  |  |  |  |  |  |  |  |  | 0178A | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-07-16 00:00:00 | 13:04:24
3018768 | 3018768 | R:5010664 | 5010664 | R:5010656 | 5010656 |  |  |  |  |  |  |  |  |  | 0178A | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-07-16 00:00:00 | 13:04:31
3018769 | 3018769 | R:5010664 | 5010664 | R:5010656 | 5010656 |  |  |  |  |  |  |  |  |  | 0178A | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-07-16 00:00:00 | 13:04:37
3018770 | 3018770 | R:5010664 | 5010664 | R:5010656 | 5010656 |  |  |  |  |  |  |  |  |  | 0178A | CHUM SALMON FROZEN VP PAVE 90-120 GRAM ECP 10 KG CARTON | 10 KG CARTON | 2020-07-16 00:00:00 | 13:04:45