Replace Null Values in a Column
 

I need to replace null values in all the cells of a column with the value in
the cell directly above it. Can I run something in the next column to
accomplish this?

Example:
A B
1 $5
2
3 $3
4 $7
5

Desired Result:
Example:
A B
1 $5 $5
2 $5
3 $3 $3
4 $7 $7
5 $7

Replace Null Values in a Column
 

You can do it right in the same column.

Select your range
Hit F5
Click "Special"
Click "Blanks"
Then <OK
Type the Equal (=) sign
Hit the UpArrow
Hit <Ctrl <Enter

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steve C" wrote in message
...
I need to replace null values in all the cells of a column with the value
in
the cell directly above it. Can I run something in the next column to
accomplish this?

Example:
A B
1 $5
2
3 $3
4 $7
5

Desired Result:
Example:
A B
1 $5 $5
2 $5
3 $3 $3
4 $7 $7
5 $7

Replace Null Values in a Column
 

hi
you could use a helper column next to the column with the null values.
assuming the values are in column A, in the helper column put this...
=if(A2="",A1,A2)

Regards
FSt1

"Steve C" wrote:

I need to replace null values in all the cells of a column with the value in
the cell directly above it. Can I run something in the next column to
accomplish this?

Example:
A B
1 $5
2
3 $3
4 $7
5

Desired Result:
Example:
A B
1 $5 $5
2 $5
3 $3 $3
4 $7 $7
5 $7

Replace Null Values in a Column
 

There are instructions here for filling the blank cells in a column:

http://www.contextures.com/xlDataEntry02.html

Or, if you need to do it in the adjacent column, you can use a formula.
For example, in cell B2: =IF(A2="",B1,A2)


Steve C wrote:
I need to replace null values in all the cells of a column with the value in
the cell directly above it. Can I run something in the next column to
accomplish this?

Example:
A B
1 $5
2
3 $3
4 $7
5

Desired Result:
Example:
A B
1 $5 $5
2 $5
3 $3 $3
4 $7 $7
5 $7



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Replace Null Values in a Column
 

For A1, read B1?
--
David Biddulph

"FSt1" wrote in message
...
hi
you could use a helper column next to the column with the null values.
assuming the values are in column A, in the helper column put this...
=if(A2="",A1,A2)

Regards
FSt1

"Steve C" wrote:

I need to replace null values in all the cells of a column with the value
in
the cell directly above it. Can I run something in the next column to
accomplish this?

Example:
A B
1 $5
2
3 $3
4 $7
5

Desired Result:
Example:
A B
1 $5 $5
2 $5
3 $3 $3
4 $7 $7
5 $7