big big problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Data>filter>advanced filter, copy to another location and select unique
records only


--


Regards,


Peo Sjoblom
 
Back
Top