Spreadsheet: 481621d1474555477-drawing-the-latest-information-from-a-range-of-numbers-excelforum
Sheet: Sheet1

CYLINDER # |  |  | CYLINDER LOCATION CODE | receipt_date | receipt_time | lastupddate | lastupdtime
308172 | CYLRECEIPT | SBK | 05270522 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05271372 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05271599 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05271631 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05273855 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05273861 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05273901 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05273893 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05273892 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05273919 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05273878 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05273897 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28 |  |  | This is a list of movements made by cylinders in the last 3 years.
308172 | CYLRECEIPT | SBK | 05273894 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28 |  |  | Each cylinder has an item code. We want to remove the entries for each item, leaving only the last entry.
308172 | CYLRECEIPT | SBK | 05273915 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28 |  |  | The last entry tells us where the cylinder is stored now.
308172 | CYLRECEIPT | SBK | 05273913 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
308172 | CYLRECEIPT | SBK | 05273931 | 2013-10-23 00:00:00 | 10:27:18 | 2016-05-19 00:00:00 | 14:39:28
301208 | CYLRECEIPT | SBK | 05271031 | 2013-11-05 00:00:00 | 11:39:54 | 2016-05-16 00:00:00 | 19:55:34 |  |  |  | I want red removed, green kept. I need a way to apply it to the entire list.
301208 | CYLRECEIPT | SBK | 05270937 | 2013-11-05 00:00:00 | 11:39:54 | 2016-05-16 00:00:00 | 19:55:34
301208 | CYLRECEIPT | SBK | 08273613 | 2013-11-05 00:00:00 | 11:39:54 | 2016-05-16 00:00:00 | 19:55:34
301208 | CYLRECEIPT | SBK | 05273900 | 2013-11-05 00:00:00 | 11:39:54 | 2016-05-16 00:00:00 | 19:55:34
301208 | CYLRECEIPT | SBK | 05273891 | 2013-11-05 00:00:00 | 11:39:54 | 2016-05-16 00:00:00 | 19:55:34
223861 | CYLRECEIPT | SBK | 05270524 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 05270770 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 05271331 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 05271570 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 08272140 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 05271606 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 08271947 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 05271508 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 08271897 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 08271993 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 08272360 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 08272261 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
223861 | CYLRECEIPT | SBK | 08273635 | 2013-11-26 00:00:00 | 11:12:20 | 2016-09-08 00:00:00 | 16:24:07
224235 | CYLRECEIPT | SBK | 08272340 | 2013-12-13 00:00:00 | 11:21:33 | 2016-03-02 00:00:00 | [NAME]
224235 | CYLRECEIPT | SBK | 05273869 | 2013-12-13 00:00:00 | 11:21:33 | 2016-03-02 00:00:00 | [NAME]
224235 | CYLRECEIPT | SBK | 05273899 | 2013-12-13 00:00:00 | 11:21:33 | 2016-03-02 00:00:00 | [NAME]
224235 | CYLRECEIPT | SBK | 05273858 | 2013-12-13 00:00:00 | 11:21:33 | 2016-03-02 00:00:00 | [NAME]
224235 | CYLRECEIPT | SBK | 05273864 | 2013-12-13 00:00:00 | 11:21:33 | 2016-03-02 00:00:00 | [NAME]
224235 | CYLRECEIPT | SBK | 05273850 | 2013-12-13 00:00:00 | 11:21:33 | 2016-03-02 00:00:00 | [NAME]
224135 | CYLRECEIPT | SBK | 08272386 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 05270861 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 05271569 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 08271946 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 05273909 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 05273895 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 05273908 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 05273872 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 05273869 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 05273874 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 05273865 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
224135 | CYLRECEIPT | SBK | 05273850 | 2014-01-07 00:00:00 | 12:39:05 | 2016-03-02 00:00:00 | 09:04:54
223827 | CYLRECEIPT | SBK | 05271059 | 2014-01-21 00:00:00 | 12:04:39 | 2016-09-21 00:00:00 | 06:19:00
223827 | CYLRECEIPT | SBK | 08272817 | 2014-01-21 00:00:00 | 12:04:39 | 2016-09-21 00:00:00 | 06:19:00
223827 | CYLRECEIPT | SBK | 08272693 | 2014-01-21 00:00:00 | 12:04:39 | 2016-09-21 00:00:00 | 06:19:00
223827 | CYLRECEIPT | SBK | 08272618 | 2014-01-21 00:00:00 | 12:04:39 | 2016-09-21 00:00:00 | 06:19:00
313424 | CYLRECEIPT | SBK | 08273419 | 2014-01-27 00:00:00 | 07:26:45 | 2016-02-29 00:00:00 | 14:27:53
313424 | CYLRECEIPT | SBK | 08273484 | 2014-01-27 00:00:00 | 07:26:45 | 2016-02-29 00:00:00 | 14:27:53
313424 | CYLRECEIPT | SBK | 05273147 | 2014-01-27 00:00:00 | 07:26:45 | 2016-02-29 00:00:00 | 14:27:53
313424 | CYLRECEIPT | SBK | 08273679 | 2014-01-27 00:00:00 | 07:26:45 | 2016-02-29 00:00:00 | 14:27:53
313424 | CYLRECEIPT | SBK | 08273557 | 2014-01-27 00:00:00 | 07:26:45 | 2016-02-29 00:00:00 | 14:27:53
313424 | CYLRECEIPT | SBK | 08273626 | 2014-01-27 00:00:00 | 07:26:45 | 2016-02-29 00:00:00 | 14:27:53
313424 | CYLRECEIPT | SBK | 05271012 | 2014-01-27 00:00:00 | 07:26:45 | 2016-02-29 00:00:00 | 14:27:53
301374 | CYLRECEIPT | SBK | 05271111 | 2014-01-29 00:00:00 | 12:15:37 | 2016-03-02 00:00:00 | 09:03:59
301374 | CYLRECEIPT | SBK | 05273078 | 2014-01-29 00:00:00 | 12:15:37 | 2016-03-02 00:00:00 | 09:03:59
301374 | CYLRECEIPT | SBK | 08272362 | 2014-01-29 00:00:00 | 12:15:37 | 2016-03-02 00:00:00 | 09:03:59
301374 | CYLRECEIPT | SBK | 08272682 | 2014-01-29 00:00:00 | 12:15:37 | 2016-03-02 00:00:00 | 09:03:59
301374 | CYLRECEIPT | SBK | 08272291 | 2014-01-29 00:00:00 | 12:15:37 | 2016-03-02 00:00:00 | 09:03:59
301374 | CYLRECEIPT | SBK | 08272751 | 2014-01-29 00:00:00 | 12:15:37 | 2016-03-02 00:00:00 | 09:03:59
301374 | CYLRECEIPT | SBK | 05273885 | 2014-01-29 00:00:00 | 12:15:37 | 2016-03-02 00:00:00 | 09:03:59
301374 | CYLRECEIPT | SBK | 05273858 | 2014-01-29 00:00:00 | 12:15:37 | 2016-03-02 00:00:00 | 09:03:59
301374 | CYLRECEIPT | SBK | 05273864 | 2014-01-29 00:00:00 | 12:15:37 | 2016-03-02 00:00:00 | 09:03:59
301374 | CYLRECEIPT | SBK | 05273850 | 2014-01-29 00:00:00 | 12:15:37 | 2016-03-02 00:00:00 | 09:03:59
300585 | CYLRECEIPT | SBK | 05270852 | 2014-02-27 00:00:00 | 12:48:00 | 2016-09-21 00:00:00 | 18:05:37
300585 | CYLRECEIPT | SBK | 05270850 | 2014-02-27 00:00:00 | 12:48:00 | 2016-09-21 00:00:00 | 18:05:37
300585 | CYLRECEIPT | SBK | 05271568 | 2014-02-27 00:00:00 | 12:48:00 | 2016-09-21 00:00:00 | 18:05:37
300585 | CYLRECEIPT | SBK | 05271293 | 2014-02-27 00:00:00 | 12:48:00 | 2016-09-21 00:00:00 | 18:05:37
300585 | CYLRECEIPT | SBK | 05271542 | 2014-02-27 00:00:00 | 12:48:00 | 2016-09-21 00:00:00 | 18:05:37
300585 | CYLRECEIPT | SBK | 08271808 | 2014-02-27 00:00:00 | 12:48:00 | 2016-09-21 00:00:00 | 18:05:37
300585 | CYLRECEIPT | SBK | 08272805 | 2014-02-27 00:00:00 | 12:48:00 | 2016-09-21 00:00:00 | 18:05:37
300585 | CYLRECEIPT | SBK | 08272658 | 2014-02-27 00:00:00 | 12:48:00 | 2016-09-21 00:00:00 | 18:05:37
300585 | CYLRECEIPT | SBK | 08272189 | 2014-02-27 00:00:00 | 12:48:00 | 2016-09-21 00:00:00 | 18:05:37
300585 | CYLRECEIPT | SBK | 08273557 | 2014-02-27 00:00:00 | 12:48:00 | 2016-09-21 00:00:00 | 18:05:37
313789 | CYLRECEIPT | SBK | 08271797 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 08272251 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 05271444 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 08271799 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 08271776 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 05270626 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 05270685 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 08272275 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 08272649 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 08272681 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 08273732 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21
313789 | CYLRECEIPT | SBK | 08272294 | 2014-03-07 00:00:00 | 11:40:36 | 2016-09-21 00:00:00 | 14:31:21