Duplicate Info

[Hooter]

Hi

Is there way of removing duplicate info in the same cells

ie,

brown fox
yellow fox
brown fox
brown fox
blue fox

after action

brown fox
yellow fox
blue fox

Rgds Simon

 

[JE McGimpsey]

Check out the info on Advanced Filter (using unique values only) in XL
Help, or at

http://www.contextures.com/xladvfilter01.html

 

[Gord Dibben]

Hooter

"In the same cells" means all the foxes are in one cell?

Gord Dibben Excel MVP

 

[Hooter]

Sorry I ment

A
1 brown fox
2 yellow fox
3 brown fox
4 brown fox
5 blue fox

I need a formula that will look at column A, five cells and remove any
duplicate info.
ie.
A
1 brown fox
2 yellow fox
3 blue fox

Brgds Simon

 

[Gord Dibben]

Hooter

In that case, see J.E.'s response to your post.

Which was.....go to Debra Dalgleish's site for info on filtering out
duplicates.

http://www.contextures.on.ca/xladvfilter01.html#FilterUR

Gord