IF ISBLANK formula using...

[Babi_mn]

Hello guys
I can not paste my value into only empty cell. I want to Copy F column numbers into C column only after yellow highlighted rows, which means right next to empty B cell.
here I attached screen shot of my Sheet. problem is I have 97k rows of it
Please help. How do I use IF or ISBLANK formula on this..?

 

[BigBeachBananas]

How about this? Pate in an empty column row 1 & fill down.

=IF(ISBLANK(B1),OFFSET($F$1,ROW(B1)/2-1,0),B1)

Edit: This would not work. Did not notice the continuous empty cells.

 

[Babi_mn]

How about this? Pate in an empty column row 1 & fill down.

=IF(ISBLANK(B1),OFFSET($F$1,ROW(B1)/2-1,0),B1)

Edit: This would not work. Did not notice the continuous empty cells.

wow mister, this worked like a charm, Thanks a Lot

 

[BigBeachBananas]

wow mister, this worked like a charm, Thanks a Lot

It should've only worked on every other blank cell. If there's a continuous range of empty cells you would get the wrong result. It's hard for you to see because a lot of the values in F are repeated.

 

[Babi_mn]

It should've only worked on every other blank cell. If there's a continuous range of empty cells you would get the wrong result. It's hard for you to see because a lot of the values in F are repeated.

oh, thats right, some cells are duplicated.

 

[BigBeachBananas]

This should work but needs a few extra columns. Copy the formulas into columns C,D & E. Adjust the rows as needed.
Column E is the final result.

Book1
	A	B	C	D	E	F
1	1	2	0	0	2	25
2	1		1	1	25	11
3	2	5	0	1	5	18
4	2		1	2	11	16
5	3	1	0	2	1	2
6	3		1	3	18	8
7	4	6	0	3	6	1
8	4		1	4	16	6
9	5	8	0	4	8	2
10	5		1	5	2	3
11	6		1	6	8	4
12	6		1	7	1
13	7		1	8	6
14	7		1	9	2
15	8		1	10	3
16	8	10	0	10	10
Sheet3

Cell Formulas
Range	Formula
C1:C16	C1	=--(B1:B16="")
D1:D16	D1	=SUM($C$1:C1)
E1	E1	=B1
E2:E16	E2	=IF(ISBLANK(B2),CHOOSEROWS(F:F,D2),B2)
Dynamic array formulas.

 

[Babi_mn]

you are expert, this let me save days of work, i have 20 sheets that contains 100k columns each. thank you very much.