Good morning experts,
I have something like this in sheet1:
NUMBER STATE last update
584527 INI 24/06/2013 23:28
584527 TIP 24/06/2013 23:45
584527 SFR 25/06/2013 00:40
584527 END 25/06/2013 02:12
580715 INI 20/06/2013 20:41
580715 TIP 20/06/2013 20:57
580715 TIP 20/06/2013 21:08
580715 TIP 20/06/2013 21:25
580715 IPS 20/06/2013 21:35
580715 END 21/06/2013 00:12
580715 INI 20/06/2013 20:36
580715 TIP 20/06/2013 20:59
580715 TIP 20/06/2013 21:03
580715 TIP 20/06/2013 21:26
580715 IPS 20/06/2013 21:39
580715 END 21/06/2013 00:09
593649 INI 06/07/2013 08:46
593649 TIP 06/07/2013 12:30
593649 IPS 06/07/2013 13:39
593649 IPS 06/07/2013 16:16
600436 INI 16/07/2013 14:18
600436 TIP 16/07/2013 14:33
600436 SFR 16/07/2013 17:30
600436 END 16/07/2013 19:47
What I want is to copy the unique values in column NUMBER, if, and only if, the STATE column isn't END and the column last update has the latest time/hour.
In this case case it would copy only the bold row - "593649 IPS 06/07/2013 16:16". Since its the only NUMBER without and END and 06/07/2013 16:16 is the last update.
Is this possible to do in VBA?
Bookmarks