He is using Advanced Filter Peo, not autofilter.

--
HTH

Bob

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

"Peo Sjoblom" wrote in message
...
It works but you need to specify only the data in column A then select the
visible cells and copy the data to another sheet


--


Regards,


Peo Sjoblom


"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