How to Sort data

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

Hi

I have a list of text in one column in this format:-

ab-21
ab-21
ab-21
ab-22
ab-22
ab-23
ab-23
ab-23
ab-23

what i need to do is just show one of each text, so it will be like this:-
ab-21
ab-22
ab-23

any ideas??

thanks
Graham
 
If you have a header row,

highlight the column

Data > Filter > Advanced Filter

Click the Unique records checkbox

Copy to another location, select your new column

Click OK
 
Advanced Filter.

Unique records only and copy to another location.


Gord Dibben MS Excel MVP
 
Back
Top