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







[TABLE="width: 506"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Ledger No[/TD]
[TD]ID#[/TD]
[TD]Src[/TD]
[TD]Account Name[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]1-1110[/TD]
[TD]A Bank [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1110[/TD]
[TD]Beginning Balance:[/TD]
[TD]$0.00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1-1111[/TD]
[TD]B Bank[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1111[/TD]
[TD]Beginning Balance:[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1111[/TD]
[TD]5069[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1111[/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1111[/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1111[/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1111[/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1111[/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1111[/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]5070[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1-1112[/TD]
[TD]C Bank[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1112[/TD]
[TD]Beginning Balance:[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1112[/TD]
[TD]5069[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1112[/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1-1112[/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]dm[/TD]
[TD]CD[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

For point 1

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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Cell[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]=IFERROR(IF(FIND("-",B2)>0,B2,A2),A2)[/TD]
[/TR]
</tbody>[/TABLE]

 

[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?