Deleting cells with repeated data

P

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
 
C

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:p[email protected]...
 
Top