Spreadsheet: 811919d1672860576-help-with-count-based-on-criteria-for-duplicates-example
Sheet: Sheet1

Order # | Route # | Sched Ready
2645427 | 1201_ANN_122422 | 12/25/2022 12:30 AM |  |  | Occurances between 12/25/22 and 12/26/22 that begins with 1
2645427 | 1201_ANN_122422 | 12/25/2022 12:30 AM
2645427 | 1201_ANN_122422 | 12/25/2022 12:30 AM
2645421 | 1202_ANN_122422 | 12/25/2022 02:00 AM |  |  | Occurances between 12/25/22 and 12/26/22 that begins with 1 minus duplicates
2645421 | 1202_ANN_122422 | 12/25/2022 02:00 AM
2645421 | 1202_ANN_122422 | 12/25/2022 02:00 AM
2645420 | 1203_ANN_122422 | 12/25/2022 02:15 AM
2645420 | 1203_ANN_122422 | 12/25/2022 02:15 AM
2645426 | 1204_ANN_122422 | 12/25/2022 02:30 AM
2645426 | 1204_ANN_122422 | 12/25/2022 02:30 AM
2645425 | 1205_ANN_122422 | 12/25/2022 03:00 AM
2645425 | 1205_ANN_122422 | 12/25/2022 03:00 AM
2645425 | 1205_ANN_122422 | 12/25/2022 03:00 AM
2645428 | 1206_ANN_122422 | 12/25/2022 03:00 AM
2645428 | 1206_ANN_122422 | 12/25/2022 03:00 AM
2645422 | 1207_ANN_122422 | 12/25/2022 03:30 AM
2645422 | 1207_ANN_122422 | 12/25/2022 03:30 AM
2645424 | 1208_ANN_122422 | 12/25/2022 03:30 AM
2645424 | 1208_ANN_122422 | 12/25/2022 03:30 AM
2645423 | 1209_ANN_122422 | 12/25/2022 04:15 AM
2645423 | 1209_ANN_122422 | 12/25/2022 04:15 AM
2646173 | 2101_ANN_122622 | 12/26/2022 01:00 PM
2646175 | 2102_ANN_122622 | 12/26/2022 01:00 PM
2646177 | 2103_ANN_122622 | 12/26/2022 01:00 PM
2646180 | 2104_ANN_122622 | 12/26/2022 01:00 PM
2646181 | 2105_ANN_122622 | 12/26/2022 01:00 PM
2646182 | 2106_ANN_122622 | 12/26/2022 01:00 PM
2646198 | 2107_ANN_122622 | 12/26/2022 01:00 PM
2646200 | 2108_ANN_122622 | 12/26/2022 01:00 PM
2646202 | 2109_ANN_122622 | 12/26/2022 01:00 PM
2646205 | 2301_ANN_122622 | 12/26/2022 01:30 PM
2646207 | 2302_ANN_122622 | 12/26/2022 01:30 PM
2646208 | 2303_ANN_122622 | 12/26/2022 02:00 PM
2646188 | 2110_ANN_122622 | 12/26/2022 02:30 PM
2646188 | 2110_ANN_122622 | 12/26/2022 02:30 PM
2646209 | 2304_ANN_122622 | 12/26/2022 02:30 PM
2646168 | 2111_ANN_122622 | 12/26/2022 03:00 PM
2646168 | 2111_ANN_122622 | 12/26/2022 03:00 PM
2646194 | 2112_ANN_122622 | 12/26/2022 04:00 PM
2646196 | 2113_ANN_122622 | 12/26/2022 04:00 PM
2646196 | 2113_ANN_122622 | 12/26/2022 04:00 PM
2646199 | 2114_ANN_122622 | 12/26/2022 04:00 PM
2646199 | 2114_ANN_122622 | 12/26/2022 04:00 PM
2646201 | 2115_ANN_122622 | 12/26/2022 04:00 PM
2646186 | 2116_ANN_122622 | 12/26/2022 04:30 PM
2646186 | 2116_ANN_122622 | 12/26/2022 04:30 PM
2646192 | 2117_ANN_122622 | 12/26/2022 04:30 PM
2646192 | 2117_ANN_122622 | 12/26/2022 04:30 PM
2646169 | 2118_ANN_122622 | 12/26/2022 05:00 PM
2646171 | 2119_ANN_122622 | 12/26/2022 05:00 PM
2646172 | 2120_ANN_122622 | 12/26/2022 05:00 PM
2646174 | 2121_ANN_122622 | 12/26/2022 05:00 PM
2646184 | 2122_ANN_122622 | 12/26/2022 05:00 PM
2646185 | 2123_ANN_122622 | 12/26/2022 05:00 PM
2646185 | 2123_ANN_122622 | 12/26/2022 05:00 PM
2646189 | 2124_ANN_122622 | 12/26/2022 05:00 PM
2646190 | 2125_ANN_122622 | 12/26/2022 05:15 PM
2646190 | 2125_ANN_122622 | 12/26/2022 05:15 PM
2646170 | 2126_ANN_122622 | 12/26/2022 05:30 PM
2646176 | 2127_ANN_122622 | 12/26/2022 05:30 PM
2646176 | 2127_ANN_122622 | 12/26/2022 05:30 PM
2646183 | 2128_ANN_122622 | 12/26/2022 05:30 PM
2646183 | 2128_ANN_122622 | 12/26/2022 05:30 PM
2646191 | 2129_ANN_122622 | 12/26/2022 05:30 PM
2646191 | 2129_ANN_122622 | 12/26/2022 05:30 PM
2646197 | 2130_ANN_122622 | 12/26/2022 05:45 PM
2646187 | 2131_ANN_122622 | 12/26/2022 06:00 PM
2646187 | 2131_ANN_122622 | 12/26/2022 06:00 PM
2646195 | 2132_ANN_122622 | 12/26/2022 06:00 PM
2646195 | 2132_ANN_122622 | 12/26/2022 06:00 PM
2646203 | 2133_ANN_122622 | 12/26/2022 06:00 PM
2646203 | 2133_ANN_122622 | 12/26/2022 06:00 PM
2646204 | 2134_ANN_122622 | 12/26/2022 06:00 PM
2646204 | 2134_ANN_122622 | 12/26/2022 06:00 PM
2646178 | 2135_ANN_122622 | 12/26/2022 07:00 PM
2646193 | 2136_ANN_122622 | 12/26/2022 07:00 PM
2646193 | 2136_ANN_122622 | 12/26/2022 07:00 PM
2646179 | 2137_ANN_122622 | 12/26/2022 08:00 PM
2646211 | 2502_ANN_122622 | 12/26/2022 09:00 PM
2646222 | 2203_ANN_122622 | 12/26/2022 11:30 PM
2646222 | 2203_ANN_122622 | 12/26/2022 11:30 PM
2646224 | 2205_ANN_122622 | 12/27/2022 12:30 AM
2646224 | 2205_ANN_122622 | 12/27/2022 12:30 AM
2646226 | 2206_ANN_122622 | 12/27/2022 12:30 AM
2646226 | 2206_ANN_122622 | 12/27/2022 12:30 AM
2646223 | 2208_ANN_122622 | 12/27/2022 01:00 AM
2646223 | 2208_ANN_122622 | 12/27/2022 01:00 AM
2646218 | 2211_ANN_122622 | 12/27/2022 02:30 AM
2646218 | 2211_ANN_122622 | 12/27/2022 02:30 AM
2646228 | 2212_ANN_122622 | 12/27/2022 02:30 AM
2646228 | 2212_ANN_122622 | 12/27/2022 02:30 AM
2646227 | 2213_ANN_122622 | 12/27/2022 03:30 AM
2646227 | 2213_ANN_122622 | 12/27/2022 03:30 AM
2646227 | 2213_ANN_122622 | 12/27/2022 03:30 AM
2646227 | 2213_ANN_122622 | 12/27/2022 03:30 AM
2646212 | 2214_ANN_122622 | 12/27/2022 04:30 AM
2646212 | 2214_ANN_122622 | 12/27/2022 04:30 AM
2646212 | 2214_ANN_122622 | 12/27/2022 04:30 AM
2646225 | 2215_ANN_122622 | 12/27/2022 04:30 AM
2646225 | 2215_ANN_122622 | 12/27/2022 04:30 AM
2646225 | 2215_ANN_122622 | 12/27/2022 04:30 AM
2646229 | 2217_ANN_122622 | 12/27/2022 05:30 AM
2646229 | 2217_ANN_122622 | 12/27/2022 05:30 AM
2646229 | 2217_ANN_122622 | 12/27/2022 05:30 AM
2646219 | 2218_ANN_122622 | 12/27/2022 06:30 AM
2646219 | 2218_ANN_122622 | 12/27/2022 06:30 AM
2649868 | [PHONE] | 12/27/2022 07:00 AM
2649868 | [PHONE] | 12/27/2022 07:00 AM
2646206 | 2501_ANN_122622 | 12/27/2022 11:00 AM
2647177 | 3301_ANN_122722 | 12/27/2022 01:30 PM
2647178 | 3302_ANN_122722 | 12/27/2022 01:30 PM
2647167 | 3101_ANN_122722 | 12/27/2022 02:00 PM
2647173 | 3102_ANN_122722 | 12/27/2022 02:00 PM
2647179 | 3303_ANN_122722 | 12/27/2022 02:00 PM
2647180 | 3304_ANN_122722 | 12/27/2022 02:30 PM
2647168 | 3103_ANN_122722 | 12/27/2022 03:00 PM
2647168 | 3103_ANN_122722 | 12/27/2022 03:00 PM
2647168 | 3103_ANN_122722 | 12/27/2022 03:00 PM
2647168 | 3103_ANN_122722 | 12/27/2022 03:00 PM
2647171 | 3104_ANN_122722 | 12/27/2022 04:00 PM
2647171 | 3104_ANN_122722 | 12/27/2022 04:00 PM
2647171 | 3104_ANN_122722 | 12/27/2022 04:00 PM
2647163 | 3105_ANN_122722 | 12/27/2022 04:30 PM
2647163 | 3105_ANN_122722 | 12/27/2022 04:30 PM
2647163 | 3105_ANN_122722 | 12/27/2022 04:30 PM
2647169 | 3106_ANN_122722 | 12/27/2022 05:00 PM
2647169 | 3106_ANN_122722 | 12/27/2022 05:00 PM
2647169 | 3106_ANN_122722 | 12/27/2022 05:00 PM
2647169 | 3106_ANN_122722 | 12/27/2022 05:00 PM
2647169 | 3106_ANN_122722 | 12/27/2022 05:00 PM
2647170 | 3107_ANN_122722 | 12/27/2022 05:00 PM
2647170 | 3107_ANN_122722 | 12/27/2022 05:00 PM
2647170 | 3107_ANN_122722 | 12/27/2022 05:00 PM
2647165 | 3108_ANN_122722 | 12/27/2022 05:15 PM
2647165 | 3108_ANN_122722 | 12/27/2022 05:15 PM
2647165 | 3108_ANN_122722 | 12/27/2022 05:15 PM
2647165 | 3108_ANN_122722 | 12/27/2022 05:15 PM
2647166 | 3109_ANN_122722 | 12/27/2022 05:30 PM
2647166 | 3109_ANN_122722 | 12/27/2022 05:30 PM
2647175 | 3110_ANN_122722 | 12/27/2022 05:30 PM
2647175 | 3110_ANN_122722 | 12/27/2022 05:30 PM
2647175 | 3110_ANN_122722 | 12/27/2022 05:30 PM
2647175 | 3110_ANN_122722 | 12/27/2022 05:30 PM
2647176 | 3111_ANN_122722 | 12/27/2022 05:30 PM
2647176 | 3111_ANN_122722 | 12/27/2022 05:30 PM
2647172 | 3112_ANN_122722 | 12/27/2022 06:00 PM
2647172 | 3112_ANN_122722 | 12/27/2022 06:00 PM
2647174 | 3113_ANN_122722 | 12/27/2022 06:30 PM
2647174 | 3113_ANN_122722 | 12/27/2022 06:30 PM
2647174 | 3113_ANN_122722 | 12/27/2022 06:30 PM
2647174 | 3113_ANN_122722 | 12/27/2022 06:30 PM
2647164 | 3114_ANN_122722 | 12/27/2022 07:00 PM
2647164 | 3114_ANN_122722 | 12/27/2022 07:00 PM
2647194 | 3201_ANN_122722 | 12/27/2022 07:15 PM
2647194 | 3201_ANN_122722 | 12/27/2022 07:15 PM
2647550 | 3212_ANN_122822 | 12/27/2022 09:00 PM
2647550 | 3212_ANN_122822 | 12/27/2022 09:00 PM
2647550 | 3212_ANN_122822 | 12/27/2022 09:00 PM
2647182 | 3502_ANN_122722 | 12/27/2022 09:00 PM
2647183 | 3503_ANN_122722 | 12/27/2022 09:00 PM