How to Sort data
 

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

How to Sort data
 

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

"Graham" wrote:

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

How to Sort data
 

Advanced Filter.

Unique records only and copy to another location.


Gord Dibben MS Excel MVP

On Wed, 30 Sep 2009 05:35:01 -0700, Graham
wrote:

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