Deleting rows of data based on time stamp

[tpollard1]

Hello,
Can I please get some help with a macro, The keys for me are column A and column C.

Row 2 and row 3 have the same unit number whenever this is identified look at column C and only keep the row with the most current time. In this example row 3 would be kept and row 2 deleted from the spreadsheet.

My spreadsheet will have up to 100000 rows of data. Thank you all.

Tried to attach a spreadsheet hope I did it correctly.

[PCI]

We suppose that the unit number are not sorted ..?
Can we sort them?
"look at column C " and B is it?

[JieJenn]

If you sort your list by Column C then A, you can just keep your first batch and delete everything else.

[PCI]

See attached

[tpollard1]

Hello, you don't know how much I appreciate your help. I do have a follow up question thougth. I just saw in some data that I was reviewing that the date/time may not be a few seconds off like in the initial example.

With the spreadsheet you provided to me will the macro still keep the most recent item if data looks like what is in the table below, where the second date is three days later than the first date but the time on 5/4/15 is actually earlier than the time on 5/1/15. Hope that makes sense.

Unit 1 5/1/2015 17:00:40 A 71.907
Unit 1 5/4/2015 15:23:56 A 264.216

[PCI]

In the macro sent it is not only the time but the day + time which is used
Try and comment
Please give the information back concerning the treatment time

[tpollard1]

Thank you. I manipulated the data for date / time and ran the macro and it works great. Thank you again for your help.

[PCI]

What about the time spent, for example with 100000 rows, is it acceptable ?