That suggests to me that what looks like duplicates are not duplicates. Do
any have trailing spaces?

Check by using

=COUNTIF(A:A,Ax)

where x is a row that you think contains a duplicate. Do you get a result of
1?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Gaurav" wrote in message
...
it still has all the duplicates.


"Bob Phillips" wrote in message
...
Should work to get the uniques. What does not working mean?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Gaurav" wrote in message
...
Hi All,

I have looked through the forum and could not find a solution to this
problem. I think it should be easy though.

I have some data in A1:AY3990. there are many duplicates and I want to
extract only unique ones to another sheet.

The data is too much and it will take a lot of time to delete
duplicates. Some have 3 duplicates, some have 2, some have 5 etc etc.

The good thing is that if the entry in column A is duplicate, that
entire row is going to be duplicate so we actually need to find
duplicates in column A only and extract only the unique ones to sheet 2.

I have tried the Advance Filter|Unique Values Only| option. Its not
working.


Thanks in advance
Gaurav