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

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

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

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

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

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

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.


"Bob Phillips" wrote in message
...
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