Excel List

[shadowfather]

I have a large spreadsheet of data and one column contains an ammount of data that is the same. I want to make a list out of this column that shows an individual list.

I.E

one
one
two
three
one
two
four

I just want to see

one
two
three
four

Sorry if my explanation is a little vague

Cheers

Stuart

 

[GlennUK]

What version of Excel are you using?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[xlbo]

Select list

Filter>Advanced Filter

tick "Unique records only"

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[shadowfather]

Thanks for the help, tried that solution before but would not work. I have modified the data and now works.

Thanks for your help