Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easiest way to delete blank cells in column (not entire row)
Can anyone refresh my memory as to what would be the easiest way to delete
blank cells within a column of data. (Not the entire row - just individual cells and shift them up to have a list without blanks). I know there are many ways to do this, some more advanced than others, but I am looking for the most simple. Thanks in advance! -- sramsey |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easiest way to delete blank cells in column (not entire row)
Select the column
edit|goto|special check blanks edit|delete and choose to shift the cells up. sramsey wrote: Can anyone refresh my memory as to what would be the easiest way to delete blank cells within a column of data. (Not the entire row - just individual cells and shift them up to have a list without blanks). I know there are many ways to do this, some more advanced than others, but I am looking for the most simple. Thanks in advance! -- sramsey -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easiest way to delete blank cells in column (not entire row)
Thanks Dave - it didn't work for me though - I realized that they aren't
truly blanks, they contain a formula =IF(COUNTIF($A$3:$A$4823,C3)=0,C3,"") it appears that those are blanks...any new ideas? -- sramsey "Dave Peterson" wrote: Select the column edit|goto|special check blanks edit|delete and choose to shift the cells up. sramsey wrote: Can anyone refresh my memory as to what would be the easiest way to delete blank cells within a column of data. (Not the entire row - just individual cells and shift them up to have a list without blanks). I know there are many ways to do this, some more advanced than others, but I am looking for the most simple. Thanks in advance! -- sramsey -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easiest way to delete blank cells in column (not entire row)
Are you sure you want to delete just the cells and shift up?
This sounds like you'll end up with a bunch of inconsistent formulas--going down that column, that is. I would cheat a bit. This formula: =IF(COUNTIF($A$3:$A$4823,C3)=0,C3,"") would change to: =IF(COUNTIF($A$3:$A$4823,C3)=0,C3,na()) Then use the same kind of technique: Select the column edit|goto|special check formulas but only check errors edit|delete and choose to shift the cells up. Then change those formulas back. sramsey wrote: Thanks Dave - it didn't work for me though - I realized that they aren't truly blanks, they contain a formula =IF(COUNTIF($A$3:$A$4823,C3)=0,C3,"") it appears that those are blanks...any new ideas? -- sramsey "Dave Peterson" wrote: Select the column edit|goto|special check blanks edit|delete and choose to shift the cells up. sramsey wrote: Can anyone refresh my memory as to what would be the easiest way to delete blank cells within a column of data. (Not the entire row - just individual cells and shift them up to have a list without blanks). I know there are many ways to do this, some more advanced than others, but I am looking for the most simple. Thanks in advance! -- sramsey -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easiest way to delete blank cells in column (not entire row)
Dave - You're aweseome! Thanks so much for the help...that worked perfect!
-- sramsey "Dave Peterson" wrote: Are you sure you want to delete just the cells and shift up? This sounds like you'll end up with a bunch of inconsistent formulas--going down that column, that is. I would cheat a bit. This formula: =IF(COUNTIF($A$3:$A$4823,C3)=0,C3,"") would change to: =IF(COUNTIF($A$3:$A$4823,C3)=0,C3,na()) Then use the same kind of technique: Select the column edit|goto|special check formulas but only check errors edit|delete and choose to shift the cells up. Then change those formulas back. sramsey wrote: Thanks Dave - it didn't work for me though - I realized that they aren't truly blanks, they contain a formula =IF(COUNTIF($A$3:$A$4823,C3)=0,C3,"") it appears that those are blanks...any new ideas? -- sramsey "Dave Peterson" wrote: Select the column edit|goto|special check blanks edit|delete and choose to shift the cells up. sramsey wrote: Can anyone refresh my memory as to what would be the easiest way to delete blank cells within a column of data. (Not the entire row - just individual cells and shift them up to have a list without blanks). I know there are many ways to do this, some more advanced than others, but I am looking for the most simple. Thanks in advance! -- sramsey -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
how can i fill blank cells in column with abc while the right col. | Excel Discussion (Misc queries) |