Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using data from coloured cells in a chart | Excel Worksheet Functions | |||
Deleting data in cells while saving formatting & formulas | New Users to Excel | |||
Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel |