Lists

[Guest]

If I have a list of say, 100 values (Cells A1-A100), and there many
duplicates, is there a way to create a "master" list elsewhere that does NOT
contain the duplicates. Thanks.

 

[Guest]

Hi,

You can solve this problem by using Advanced Filter option in Excel.

For example

A (Column)

Name
a
c
a
e
a
d
a
e

Just click on the label (in the above example it is Name (Cell A1), And then
click

Data--> Advanced Filter --> And then click the check box, Unique records
only check box. And also give the cell address in which you want to display
the unique records (Copy to option in dialog box, example B1).

Then you will get the following output

A B
name name
a a
c c
a e
e d
a
d
a
e


Hope this will clear your doubt.

Regards,
Soundar

 

[Guest]

An alternative would be to run the list through a pivot table - the output
would be unique. You could then copy and paste special it to any place you
want.