LAMBDA to subtract previous cumulative values

[ExcelToDAX]

If I am given the following values in Cells A1:A10, how can I create a LAMBDA function to get the Expected Output that is shown in Column B? Column C has the formulas for Column B, but I want to create a LAMBDA spill function so that I don't have to drag the formula.

 

[JamesCanale]

Not a lambda, but a spiller. I broke it into more steps then it needed to be in, but it is clearer.

MrExcelPlayground23.xlsx
	A	B
1	Data	Output
2	580140	580140
3	1220346	640206
4	1872330	651984
5	2821861	949531
6	3616416	794555
7	4434962	818546
8	5137115	702153
9	5889631	752516
10	6671512	781881
Sheet15

Cell Formulas
Range	Formula
B2:B10	B2	=LET(a,A2:A10,b,VSTACK(0,a),c,DROP(b,-1),a-c)
Dynamic array formulas.

Or just:

=A2:A10-DROP(VSTACK(0,A2:A10),-1)

 

[Scott Huish]

Also:
=IFERROR(A2:A10-A1:A9,A2)

Book1
	A	B
1	Data	Output
2	580140	580140
3	1220346	640206
4	1872330	651984
5	2821861	949531
6	3616416	794555
7	4434962	818546
8	5137115	702153
9	5889631	752516
10	6671512	781881
Sheet1

Cell Formulas
Range	Formula
B2:B10	B2	=IFERROR(A2:A10-A1:A9,A2)
Dynamic array formulas.

 

[Dave Patton]

T202408a.xlsm
	A		C	D
1	Data		Output	Output
2	580,140		580,140	580,140
3	1,220,346		640,206	640,206
4	1,872,330		651,984	651,984
5	2,821,861		949,531	949,531
6	3,616,416		794,555	794,555
7	4,434,962		818,546	818,546
8	5,137,115		702,153	702,153
9	5,889,631		752,516	752,516
10	6,671,512		781,881	781,881
11
1a

Cell Formulas
Range	Formula
C2:C10	C2	=A2:A10-N(+A1:A9)
D2:D10	D2	=Differential(A2:A10)
Dynamic array formulas.

Lambda Functions
Name	Formula
Differential	=LAMBDA(rngNums,rngNums-DROP(VSTACK(0,rngNums),-1))