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

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

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

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

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