Spreadsheet: 861749d1709588429-find-min-lowest-value-only-after-max-highest-value-is-found-in-a-range-of-data-high-low
Sheet: Sheet1

Symbol | Open Time | Open | High | Low | Close | Close Time |  | ENTER DAY in J2 | 2024-03-03 00:00:00
XRPUSDT | 2024-03-03 22:00:00 | 0.63301 | 0.66 | 0.6291 | 0.6293 | 2024-03-03 22:00:59.999000 |  | ENTER TIME in J3 | 22:13:00
XRPUSDT | 2024-03-03 22:01:00 | 0.6293 | 0.66 | 0.62418 | 0.629 | 2024-03-03 22:01:59.999000
XRPUSDT | 2024-03-03 22:02:00 | 0.629 | 0.66 | 0.62421 | 0.6289 | 2024-03-03 22:02:59.999000 |  | COMBINED DAY + TIME
XRPUSDT | 2024-03-03 22:03:00 | 0.629 | 0.6295 | 0.6289 | 0.6295 | 2024-03-03 22:03:59.999000
XRPUSDT | 2024-03-03 22:04:00 | 0.6295 | 0.633 | 0.6295 | 0.6296 | 2024-03-03 22:04:59.999000
XRPUSDT | 2024-03-03 22:05:00 | 0.6296 | 0.6297 | 0.6285 | 0.6285 | 2024-03-03 22:05:59.999000 |  |  | "Results using DROP & MATCH Formula" | "Results using manual checks"
XRPUSDT | 2024-03-03 22:06:00 | 0.6285 | 0.66 | 0.6284 | 0.6287 | 2024-03-03 22:06:59.999000
XRPUSDT | 2024-03-03 22:07:00 | 0.6286 | 0.6286 | 0.628 | 0.6281 | 2024-03-03 22:07:59.999000 |  | HIGH
XRPUSDT | 2024-03-03 22:08:00 | 0.628 | 0.6294 | 0.628 | 0.6292 | 2024-03-03 22:08:59.999000 |  | LOW After HIGH
XRPUSDT | 2024-03-03 22:09:00 | 0.6292 | 0.6295 | 0.6291 | 0.6294 | 2024-03-03 22:09:59.999000
XRPUSDT | 2024-03-03 22:10:00 | 0.6294 | 0.633 | 0.62421 | 0.629 | 2024-03-03 22:10:59.999000
XRPUSDT | 2024-03-03 22:11:00 | 0.6289 | 0.6295 | 0.62417 | 0.6292 | 2024-03-03 22:11:59.999000
XRPUSDT | 2024-03-03 22:12:00 | 0.6291 | 0.6296 | 0.6291 | 0.6292 | 2024-03-03 22:12:59.999000
XRPUSDT | 2024-03-03 22:13:00 | 0.6293 | 0.6299 | 0.629 | 0.6298 | 2024-03-03 22:13:59.999000
XRPUSDT | 2024-03-03 22:23:00 | 0.6299 | 0.63 | 0.6297 | 0.63 | 2024-03-03 22:23:59.999000
XRPUSDT | 2024-03-03 22:24:00 | 0.63 | 0.6306 | 0.6298 | 0.6306 | 2024-03-03 22:24:59.999000
XRPUSDT | 2024-03-03 22:25:00 | 0.6305 | 0.6307 | 0.6302 | 0.6303 | 2024-03-03 22:25:59.999000
XRPUSDT | 2024-03-03 22:26:00 | 0.6304 | 0.6304 | 0.6302 | 0.6303 | 2024-03-03 22:26:59.999000
XRPUSDT | 2024-03-03 22:27:00 | 0.6303 | 0.633 | 0.6301 | 0.6304 | 2024-03-03 22:27:59.999000
XRPUSDT | 2024-03-03 22:28:00 | 0.6304 | 0.6315 | 0.6304 | 0.6315 | 2024-03-03 22:28:59.999000
XRPUSDT | 2024-03-03 22:45:00 | 0.6327 | 0.6328 | 0.6323 | 0.6324 | 2024-03-03 22:45:59.999000
XRPUSDT | 2024-03-03 23:23:00 | 0.6285 | 0.6286 | 0.6285 | 0.6285 | 2024-03-03 23:23:59.999000
XRPUSDT | 2024-03-03 23:40:00 | 0.6257 | 0.6261 | 0.6256 | 0.6257 | 2024-03-03 23:40:59.999000
XRPUSDT | 2024-03-03 23:41:00 | 0.6257 | 0.6257 | 0.6251 | 0.6253 | 2024-03-03 23:41:59.999000
XRPUSDT | 2024-03-03 23:42:00 | 0.6254 | 0.6262 | 0.6254 | 0.626 | 2024-03-03 23:42:59.999000
XRPUSDT | 2024-03-03 23:43:00 | 0.6259 | 0.626 | 0.6242 | 0.6248 | 2024-03-03 23:43:59.999000
XRPUSDT | 2024-03-03 23:44:00 | 0.6248 | 0.6254 | 0.6247 | 0.6254 | 2024-03-03 23:44:59.999000
XRPUSDT | 2024-03-03 23:45:00 | 0.6253 | 0.626 | 0.6251 | 0.6257 | 2024-03-03 23:45:59.999000
XRPUSDT | 2024-03-03 23:56:00 | 0.6264 | 0.627 | 0.6262 | 0.627 | 2024-03-03 23:56:59.999000
XRPUSDT | 2024-03-03 23:57:00 | 0.627 | 0.6274 | 0.6269 | 0.6272 | 2024-03-03 23:57:59.999000
XRPUSDT | 2024-03-03 23:58:00 | 0.6273 | 0.6278 | 0.6271 | 0.6276 | 2024-03-03 23:58:59.999000
XRPUSDT | 2024-03-03 23:59:00 | 0.6276 | 0.628 | 0.6269 | 0.6271 | 2024-03-03 23:59:59.999000