Extracting unique entries

[Gaurav]

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

 

[Bob Phillips]

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]

it still has all the duplicates.

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)

 

[Peo Sjoblom]

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

 

[Bob Phillips]

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)

 

[Bob Phillips]

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]

I selected column A and used advanced filter with copy unique records to
other location. It worked. But I had data in 51 columns corresponding to
column A so i used VLOOKUP to return the rest of the data. Although it
worked, I feel that there should be an easier way of acheiving this.