How to Sort data

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
 
S

Sean Timmons

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
 
G

Gord Dibben

Advanced Filter.

Unique records only and copy to another location.


Gord Dibben MS Excel MVP
 
Top