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