Excel: Deleted older rows


Hi All, I've been at this solely now for a couple of days and am pulling my hair out. I have a sheet with a couple of thousand rows of info of computer hardware. I need to delete the old warranty information and leave only the newest or latest info. In the sample sheet attached the computer with serial number 84456 on row 2 and 3 is the same computer, so I need to remove one of these lines (does't matter which one). Row 4 and 5, again same computer but the warranty detail on line 4 is newer so I need to keep this row and remove the older info (row 5). Row 6, 7 & 8, again all the same computer but row 7's warranty detail is newer so this needs to stay and row 6 & 8 be deleted. Row 9, 10 & 11, again all the same computer but row 11 has the more resent warranty information so this row needs to stay and row 9 & 10 be deleted. I've got over 2000 of these to get through and any help you guys can offer would save me days!!!! Thanks in advance for even just reading this.

Serial Number Warranty End
84456 31/07/2015
84456 31/07/2015
22723 23/11/2016
22723 23/05/2014
64157 10/07/2016
64157 23/01/2018
64157 10/07/2016
38474 23/03/2016
38474 23/03/2016
38474 05/10/2018


This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of December 09, 2014.


For more resources for Microsoft Excel