Trying to identify and remove 1 row of data by comparing 2 separate cell values

[nexxus]

I receive a daily report detailing speed infractions for drivers. There are duplicate lines of data where the only difference is one line will be 13% over posted threshold but the next line will be 20% over posted threshold (all other info is exactly the same).

What I'm trying to do is identify duplicate line entries based on the date/time in the Alert Created column and use the Message Received information as the filtering parameters so that I can delete rows that show the 13% information while keeping the 20% information.

Alert Created	Message Received
11/22/2016 10:00:00 AM	Asset exceeded the posted speed limit by 13% or more. Asset speed was 125 km/hr
11/22/2016 10:00:00 AM	Asset exceeded the posted speed limit by 20% or more. Asset speed was 125km/hr

<tbody>
</tbody>

 

[oldbrewer]

11/22/2016 10:00:00 AM	Asset exceeded the posted speed limit by 13% or more. Asset speed was 125 km/hr	delete
11/22/2016 10:00:00 AM	Asset exceeded the posted speed limit by 20% or more. Asset speed was 125km/hr	keep
11/22/2016 10:05:00 AM	Asset exceeded the posted speed limit by 13% or more. Asset speed was 125 km/hr	delete
11/22/2016 10:05:00 AM	Asset exceeded the posted speed limit by 20% or more. Asset speed was 125km/hr	keep
11/22/2016 10:34:00 AM	Asset exceeded the posted speed limit by 13% or more. Asset speed was 125 km/hr	keep
11/22/2016 10:37:00 AM	Asset exceeded the posted speed limit by 13% or more. Asset speed was 125 km/hr	keep
11/22/2016 10:39:00 AM	Asset exceeded the posted speed limit by 13% or more. Asset speed was 125 km/hr	keep
11/22/2016 10:41:00 AM	Asset exceeded the posted speed limit by 13% or more. Asset speed was 125 km/hr	delete
11/22/2016 10:41:00 AM	Asset exceeded the posted speed limit by 20% or more. Asset speed was 125km/hr	keep
	formula in c1
	=IF(A2=A1,"delete","keep")
	at the end of the day or when you receive the data add col c then sort by col c
	moving all the delete rows to the bottom
	and delete them in one operation

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>