Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I copy values from one cell in a column down to the next c
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. |
#2
|
|||
|
|||
2 ways:
Easiest-If you click on A1 you should see a plus sign showing in the border at the bottom right. Click on that plus sign and hold down the mouse button while dragging down. Or-If the cell value increases by 1 at each row, then simply copy A1, highlight (click on next cell and drag down) and then select copy. "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. |
#3
|
|||
|
|||
Hi GSingh,
In Cell "C1" for Example Enter the Formula :- =IF(B1="",A1,IF(B1=0,A1,0)) All the Best. Paul |
#4
|
|||
|
|||
You are mixing columns and rows I believe.
Column A would be A1, A2, A3 etc. Row 1 would be A1, B1, C1 etc. Select the column or row. Hit F5SpecialBlanks. With these selected, enter an = sign in active cell then point to cell above or to left and hit CRTL + ENTER. Copy the column or row and in place EditPaste SpecialValuesOKEsc. Gord Dibben Excel MVP On Mon, 15 Aug 2005 15:27:01 -0700, 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. |
#5
|
|||
|
|||
Hi Again GSingh,
You could Also Enter in "C1" the Formula :- =IF(OR(B1="",B1=0),A1) All the Best. Paul |
#6
|
|||
|
|||
But will this place the value in the blank cell that is below?
"Paul Black" wrote: Hi GSingh, In Cell "C1" for Example Enter the Formula :- =IF(B1="",A1,IF(B1=0,A1,0)) All the Best. Paul |
#7
|
|||
|
|||
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. |
#8
|
|||
|
|||
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. |
#9
|
|||
|
|||
Ignore that. I will have Another Look at it and Re-Post.
All the Best. Paul |
#10
|
|||
|
|||
Hi GSingh,
You could Use Column "B" JUST as your Input Column. You could then Insert the Following Formula into Cell "C2" ... =IF(OR(B1="",B1=0,B1)*IF(B2="",B2=0),C1,B2) .... and Copy it Down. Therefore Column "C" will be the Results Column you are After. Hope this Helps. All the Best. Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
column values to a cell with comma seperated | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy one cell to entire column | Excel Discussion (Misc queries) | |||
How do I copy every 8th cell in a column | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |