Deleting cells with repeated data
 

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


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=491061

Deleting cells with repeated data
 

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"
wrote in message
...

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


--
petevang
------------------------------------------------------------------------
petevang's Profile:
http://www.excelforum.com/member.php...o&userid=25034
View this thread:
http://www.excelforum.com/showthread...hreadid=491061

Deleting cells with repeated data
 

petevang

You can use DataFilterAdvanced 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

On Tue, 6 Dec 2005 13:39:48 -0700, "Conan Kelly" <CTBarbarin at msn dot com
wrote:

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"
wrote in message
...

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


--
petevang
------------------------------------------------------------------------
petevang's Profile:
http://www.excelforum.com/member.php...o&userid=25034
View this thread:
http://www.excelforum.com/showthread...hreadid=491061