Hi GSingh,

You could Use Column "B" JUST as your Input Column.
You could then Insert the Following Formula into Cell "C2" ...
=IF(OR(B2="",B2=0,B1),B2)
.... and Copy it Down.
Therefore Column "C" will be the Results Column you are After.

Hope this Helps.
All the Best.
Paul



GSingh wrote:
Im sorry, I really meant:

How can I copy values from one cell in a column down to the next cell IF the
2nd cell is blank, For example:

B1 = 20
B2 =

I want the value of B1 to be copied to B2 if B2 is blank/contains a value of
Null, I have about 11,000 records like this, whe If the next cell in the
column is blank, then I need to copy the previous cells data into that cell.





"GSingh" wrote:

How can I copy values from one cell in a column down to the next cell IF the
2nd cell is blank, For example:

A1 = 20
B1 =

I want the value of A1 to be copied to B1 if B1 is blank/contains a value of
Null, I have about 11,000 records like this, whe If the next cell in the
column is blank, then I need to copy the previous cells data into that cell.