I have some data including same or unique name in different cells.

e.g

ABC
ABC
ACC
ADD
AEE
AEE

I would like to ask how can just show the same name in once(not duplicate)


result:

ABC
ACC
ADD
AEE

see:

http://www.cpearson.com/excel/ListFunctions.aspx
--
Gary''s Student - gsnu200750


"Wu" wrote:

I have some data including same or unique name in different cells.

e.g

ABC
ABC
ACC
ADD
AEE
AEE

I would like to ask how can just show the same name in once(not duplicate)


result:

ABC
ACC
ADD
AEE

If you don't have a heading then insert a new row 1 at the top of your
sheet and enter "names" in A1. Then highlight from the header down to
the bottom of your data in column A, and click on Data | Filter |
Advanced Filter. In the pop-up you should click on Unique Records only
and on Copy to another Location - specify where (eg C1). Click OK and
you will have your unique list in column C.

Hope this helps.

Pete


On Oct 23, 3:24 pm, Wu wrote:
I have some data including same or unique name in different cells.

e.g

ABC
ABC
ACC
ADD
AEE
AEE

I would like to ask how can just show the same name in once(not duplicate)

result:

ABC
ACC
ADD
AEE

Datafilteradvanced filter, copy to another location and select unique
records only


--


Regards,


Peo Sjoblom



"Wu" wrote in message
...
I have some data including same or unique name in different cells.

e.g

ABC
ABC
ACC
ADD
AEE
AEE

I would like to ask how can just show the same name in once(not duplicate)


result:

ABC
ACC
ADD
AEE