Getting unique values from duplicates

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

I have a spreadsheet with several thousand rows of data.

The number of thousands can be an important point. This will likely need a helper column ... and if it exceeds say 50,000 rows the following formulas will likely require some adjustments.

For the helper formula in column D this formula

Formula:

=IF(MATCH(A2,$A$2:$A$37,0)=ROWS($2:2),ROWS($2:2),"")

For the unique ID numbers in column E this formula

Formula:

=IFERROR(INDEX($A$2:$A$37,SMALL($D$2:$D$37,ROWS($2:2))),"")

and with the understanding that the most recent dates correspond with the first ID in each group this formula in F

Formula:

=IFERROR(INDEX($B$2:$B$37,MATCH(E2,$A$2:$A$37,0)),"")