Deleting cells with repeated data

[petevang]

If I have a list of 10 values in A1 through A10 and cells A5 and A6
contain the same number. How can I use a formula to delete the
repeating cells. I only want to see each number once. Thanks

 

[Conan Kelly]

petevang,

Please answer a couple questions for me first.

First, will the repeated values that you want to delete always be in
cells that are right next to each other?

Second, do you want to delete the cell itself or delete the values in
the cell leaving it blank?

I would do this with VBA Code (macro).

If you still need some help, I will be glad to come up with some code
for you.

Conan Kelly




"petevang" <[email protected]>
wrote in message
news[email protected]...

 

[Gord Dibben]

petevang

You can use Data>Filter>Advanced Filter to return only "unique records" and
"copy to another location".

See Debra Dalgleish's site for more on this.

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


Gord Dibben Excel MVP