Copy unique values elsewhere

[agarwaldvk]

Hi All

I have say 100 entries in column "A" in rows from row1 through t
row100. These entries may contain duplicates. These entries are no
sorted and MUST not be sorted for whatever reason!!!!!!

Say if some of the entries are like so :-

Deepak1
Deepak2
Deepak3
Deepak1
Deepak5
Deepak6
Deepak7
Deepak8
Deepak9
Deepak5
Deepak11
Deepak9
Deepak13
Deepak14


Is it possible to make a list of unique values from this original lis
(of 100 items) in another worksheet?

What I am expecting to see would be something like this :-

Deepak1
Deepak2
Deepak3
Deepak5
Deepak6
Deepak7
Deepak8
Deepak9
Deepak11
Deepak13
Deepak14

thereby removing Deepak1, Deepak5 and Deepak9 in the list of uniqu
items.

Best regards


Deepak Agarwa

 

[Debra Dalgleish]

You can use an Advanced Filter (Data>Filter>Advanced Filter) to copy the
unique values to another location. There are instructions in Excel's
Help, and here:

http://www.contextures.com/xladvfilter01.html

 

[Dave Peterson]

Debra Dalgleish has some notes how to use Data|filter|Advanced Filter to extract
unique entries.

then you can sort that list.

http://www.contextures.com/xladvfilter01.html#FilterUR