DeleteDupesQ28266891.xlsx

<div>
Worked like a charm. Thanks for the help.
</div>


Worked like a charm. Thanks for the help.

<div>
<div class="content wysiwyg-content">
I am trying to remove duplicate rows from a spreadsheet. The duplicate values are contained in Column A. When I remove the duplicates, I want to remove the older ones and keep the newest (column B contains the date). I can sort this and highlight duplicate rows and then manually delete the older ones but I'd rather do this with a formula of some kind. Is there a relatively easy way to accomplish this? See Sample Spreadsheet and Resulting Spreadheet below for example.<br />
<br />
Sample Spreadsheet<br />
<br />
--A-- &nbsp; &nbsp;------B------<br />
1234 &nbsp; 10/22/2013<br />
1234 &nbsp; 09/24/2013<br />
1234 &nbsp; 06/21/2013<br />
2876 &nbsp; 09/22/2013<br />
3456 &nbsp; 01/02/2012<br />
3456 &nbsp; 03/05/3013<br />
<br />
Resulting Spreadsheet After Removing Duplicates<br />
<br />
--A-- &nbsp; &nbsp;------B------<br />
1234 &nbsp; 10/22/2013<br />
2876 &nbsp; 09/22/2013<br />
3456 &nbsp; 03/05/3013
</div>
</div>


I am trying to remove duplicate rows from a spreadsheet. The duplicate values are contained in Column A. When I remove the duplicates, I want to remove the older ones and keep the newest (column B contains the date). I can sort this and highlight duplicate rows and then manually delete the older ones but I'd rather do this with a formula of some kind. Is there a relatively easy way to accomplish this? See Sample Spreadsheet and Resulting Spreadheet below for example.

Sample Spreadsheet

--A--    ------B------
1234   10/22/2013
1234   09/24/2013
1234   06/21/2013
2876   09/22/2013
3456   01/02/2012
3456   03/05/3013

Resulting Spreadsheet After Removing Duplicates

--A--    ------B------
1234   10/22/2013
2876   09/22/2013
3456   03/05/3013

Excel 2010 - Remove Duplicate Rows - Conditional

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.