Show value until now value occurs

[BascherPA]

Hello all,

I have a table with the following values:

Now I want to fill the next cell always with the previous value until a new value occurs.
I think I have to add an additional column.
E.g. For call C3 if A3 is empty respectively #NV than put the value of A2 in here ect. until in C7 the new value from A7 has to be put.

I think that is not that difficult but I am unfortunately not able to do that.

Thank you in advance.

Benjamin

 

[jasonb75]

I'm guessing that there must be formulas in those cells, so you just need to edit the existing formula to trap the error.
The formula in B2 would be something like

=WENNNV(existing formula;B1)

 

[BascherPA]

Hello Jason,

Yes but I am not able to fix the value of B1 because these value only has to be used for the next cells than and afterwards a new value occurs which should be the value then.
Any ideas how to implement something like "use value from B1 for C1until there is another value in B than use this value and so on"?

Benjamin

 

[jasonb75]

The reference is relative, so as it fills down in the table B1 changes to B2, B3, etc. Always looking at the row above the formula.

It works perfectly well for what you have described, as you will see from the example below. This is a method that I use frequently.
I've used a simple calculation in place of your existing formula as we don't know what that is.

Book3
	A	B
1	A	B
2	-32183	16091.5
3	#N/A	16091.5
4	#N/A	16091.5
5	#N/A	16091.5
6	#N/A	16091.5
7	#N/A	16091.5
8	#N/A	16091.5
9	-42181	21090.5
10	#N/A	21090.5
11	#N/A	21090.5
12	#N/A	21090.5
13	#N/A	21090.5
14	#N/A	21090.5
15	#N/A	21090.5
Sheet4

Cell Formulas
Range	Formula
A3:A8,A10:A15	A3	=NA()
B2:B15	B2	=IFNA(ABS(A2)/2,B1)