Duplicate in two columns

[Danad59]

I am hoping someone can help me with my problem with duplicates.

I have a data sheet with thousands of rows in two columns where first column is dates and second column consists of numbers with decimal. First I would like to find all Unique and Duplicates from column two.

Next, on all the duplicates, I would like to copy only the most recent date duplicates and delete rest of the duplicates for that value in column two.

By the way, I just know how to do basic things in Excel only.

 

[Robert Mika]

Hi Donad and welcome to the forum..

Use a tip from this site:

http://www.exceltip.com/st/Retrievin..._List/805.html

to get unique values in column C.

Then in column D:
=INDEX(A2:B,MATCH(MAX(IF(B:B=C1,A:A)),A:A,0),1)

copy down.
(This array formula confirm CTRL+SHIFT+ENTER.)

Copy and Paste your column D as Values.

 

[Danad59]

Hi Robert:

Thanks for your reply.

Unfortunately this does not work for me since I have dates in my column A. Maybe I am doing something wrong. I copied and pasted the formula:=INDEX($A$2:$A$8,MATCH(0,COUNTIF($B$2:B2,$A$2:$A$8),0)), then hit CTRL Shift Enter. Then it gives a string of numbers instead of dates in column C.

 

[Robert Mika]

Probably you have to change the format of those cells to Date.
Right click on the cell-->Format Cells-->Date