value (Column I) = value (Column E) = current cell box (Column I) - value (Column G)

[ibmy]

Hi,

is this possible:

4.5 - 9.xlsb
	E		G		I
1	Value S		Diff		Result
2	0.3
3	0.4
4	0.9
5	0.1
6	0.2
7	0.3		3		0.9
8	1.5
9	0.3		1		1.5
10	0.5
11	0.2
12	0.3		2		0.5
13	0.6
14	0.2
15	0.1
16	0.2
17	0.3		4		0.6
18	0.3
19
2a

- ignore/do not count if there is a blank cell in column G
- sample from 45k data

 

[Snakehips]

@ibmy Maybe like below?

MrXL_Aug.xlsm
	E	F	G	H	I
1	Value S		Diff		Result
2	0.3
3	0.4
4	0.9
5	0.1
6	0.2
7	0.3		3		0.9
8	1.5
9	0.3		1		1.5
10	0.5
11	0.2
12	0.3		2		0.5
13	0.6
14	0.2
15	0.1
16	0.2
17	0.3		4		0.6
18	0.3
19
Sheet7

Cell Formulas
Range	Formula
I2:I19	I2	=IF(G2="","",OFFSET(E2,-G2,))

Hope that helps.

 

[Fluff]

Another option

Fluff.xlsm
	E	F	G
1	Value S	Diff	Result
2	0.3
3	0.4
4	0.9
5	0.1
6	0.2
7	0.3	3	0.9
8	1.5
9	0.3	1	1.5
10	0.5
11	0.2
12	0.3	2	0.5
13	0.6
14	0.2
15	0.1
16	0.2
17	0.3	4	0.6
18	0.3
Data

Cell Formulas
Range	Formula
G2:G18	G2	=IF(F2="","",INDEX(E:E,ROW()-F2))