formula to copy values to adjacent cells and keep repeating until a new number is visible

[questforexcel]

Hello,

Could you please help me with 2 sets of formula:

1) A formula to place the "ID#" into the left column labelled "Ledger No" such that if there is a number, the formula should type that number if its a text then to leave it blank.
However, I would like the formula to keep repeating the numbers until a new set of "ID#" is found.
So for eg: Continue showing the value "1-1111" until "1-1112" appears.

2) This should be relatively less complex. I would like my formula to show the "Src" text in "Accout Name" tab until another unique "Src" text is visible.

Would appreciate your utmost assistance on these. Thank you

Ledger No	ID#	Src	Account Name
	1-1110	A Bank
1-1110	Beginning Balance:	$0.00
	1-1111	B Bank
1-1111	Beginning Balance:
1-1111	5069	CD
1-1111	dm	CD
1-1111	dm	CD
1-1111	dm	CD
1-1111	dm	CD
1-1111	dm	CD
1-1111	dm	CD
	5070	CD
	dm	CD
	dm	CD
	1-1112	C Bank
1-1112	Beginning Balance:
1-1112	5069	CD
1-1112	dm	CD
1-1112	dm	CD
	dm	CD

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[DanteAmor]

For point 1

I would like the formula to keep repeating the numbers until a new set of "ID#" is found

Cell	Formula
A3	=IFERROR(IF(FIND("-",B2)>0,B2,A2),A2)

<tbody>
</tbody>

 

[jtakw]

Hi,

Formula for A3 copied down:

Book1
	A	B	C
1	Ledger No	ID#	Src
2		1-1110	A Bank
3	1-1110	Beginning Balance:	$0.00
4
5
6
7		1-1111	B Bank
8	1-1111	Beginning Balance:
9	1-1111	5069	CD
10	1-1111	dm	CD
11	1-1111	dm	CD
12	1-1111	dm	CD
13	1-1111	dm	CD
14	1-1111	dm	CD
15	1-1111	dm	CD
16	1-1111	5070	CD
17	1-1111	dm	CD
18	1-1111	dm	CD
19
20		1-1112	C Bank
21	1-1112	Beginning Balance:
22	1-1112	5069	CD
23	1-1112	dm	CD
24	1-1112	dm	CD
25	1-1112	dm	CD
Sheet543

Cell Formulas
Range	Formula
A3	=IF(B3="","",IF(ISNUMBER(FIND("-",B2)),B2,A2))

I'm not understand your requirements for your 2nd question, can you explain further?