Need an equation to achieve this

[Shinod]

Hello Excel Experts,

I would like to get an equation to get daily ending balances in the right based on the daily transaction sin the left.

Thanks in Advance!

05/01/2023​	10,126.27	10,126.27		05/01/2023​	10,126.27
05/02/2023​	8.99	10,135.26		05/02/2023​	10,120.30
05/02/2023​	(4.99)	10,130.27		05/03/2023​	10,103.29
05/02/2023​	(3.99)	10,126.28		05/04/2023​	10,125.27
05/02/2023​	(3.99)	10,122.29		05/05/2023​	10,135.26
05/02/2023​	(1.99)	10,120.30		05/06/2023​	10,126.27
05/03/2023​	4.99	10,125.29		05/07/2023​	10,126.27
05/03/2023​	3.99	10,129.28		05/08/2023​	10,126.27
05/03/2023​	3.99	10,133.27		05/09/2023​	10,114.30
05/03/2023​	1.99	10,135.26		05/10/2023​	10,103.29
05/03/2023​	(21.98)	10,113.28		05/11/2023​	10,135.26
05/03/2023​	(9.99)	10,103.29		05/12/2023​	10,126.27
05/04/2023​	21.98	10,125.27		05/13/2023​	10,129.28
05/04/2023​	9.99	10,135.26		05/14/2023​	10,129.28
05/04/2023​	(9.99)	10,125.27		05/15/2023​	10,129.28
05/05/2023​	9.99	10,135.26		05/16/2023​	10,093.30
05/06/2023​	(8.99)	10,126.27		05/17/2023​	10,135.26
05/09/2023​	8.99	10,135.26		05/18/2023​	61,015.26
05/09/2023​	(9.99)	10,125.27		05/19/2023​	59,690.58
05/09/2023​	(4.99)	10,120.28		05/20/2023​	59,524.90
05/09/2023​	(3.99)	10,116.29		05/21/2023​	59,524.90
05/09/2023​	(1.99)	10,114.30		05/22/2023​	59,524.90
05/10/2023​	9.99	10,124.29		05/23/2023​	58,998.90
05/10/2023​	4.99	10,129.28		05/24/2023​	58,713.91
05/10/2023​	3.99	10,133.27		05/25/2023​	58,534.64
05/10/2023​	1.99	10,135.26		05/26/2023​	58,169.65
05/10/2023​	(21.98)	10,113.28		05/27/2023​	68,131.97
05/10/2023​	(9.99)	10,103.29		05/28/2023​	68,131.97
05/11/2023​	21.98	10,125.27		05/29/2023​	68,131.97
05/11/2023​	9.99	10,135.26		05/30/2023​	68,131.97
05/12/2023​	(8.99)	10,126.27		05/31/2023​	67,446.02
05/13/2023​	8.99	10,135.26
05/13/2023​	(3.99)	10,131.27
05/13/2023​	(1.99)	10,129.28
05/16/2023​	3.99	10,133.27
05/16/2023​	1.99	10,135.26
05/16/2023​	(21.98)	10,113.28
05/16/2023​	(9.99)	10,103.29
05/16/2023​	(9.99)	10,093.30
05/17/2023​	21.98	10,115.28
05/17/2023​	9.99	10,125.27
05/17/2023​	9.99	10,135.26
05/18/2023​	50,000.00	60,135.26
05/18/2023​	1,000.00	61,135.26
05/18/2023​	(120.00)	61,015.26
05/19/2023​	(60.00)	60,955.26
05/19/2023​	(8.99)	60,946.27
05/19/2023​	(200.00)	60,746.27
05/19/2023​	(500.00)	60,246.27
05/19/2023​	(209.32)	60,036.95
05/19/2023​	(265.00)	59,771.95
05/19/2023​	(15.00)	59,756.95
05/19/2023​	(44.13)	59,712.82
05/19/2023​	(17.25)	59,695.57
05/19/2023​	(4.99)	59,690.58
05/20/2023​	(3.99)	59,686.59
05/20/2023​	(1.99)	59,684.60
05/20/2023​	(2.00)	59,682.60
05/20/2023​	(19.79)	59,662.81
05/20/2023​	(6.99)	59,655.82
05/20/2023​	(9.99)	59,645.83
05/20/2023​	(26.99)	59,618.84
05/20/2023​	(25.00)	59,593.84
05/20/2023​	(7.99)	59,585.85
05/20/2023​	(9.99)	59,575.86
05/20/2023​	(3.99)	59,571.87
05/20/2023​	(8.99)	59,562.88
05/20/2023​	(2.99)	59,559.89
05/20/2023​	(11.99)	59,547.90
05/20/2023​	(17.00)	59,530.90
05/20/2023​	(6.00)	59,524.90
05/23/2023​	(21.98)	59,502.92
05/23/2023​	(9.99)	59,492.93
05/23/2023​	(1.72)	59,491.21
05/23/2023​	(30.00)	59,461.21
05/23/2023​	(19.93)	59,441.28
05/23/2023​	(158.96)	59,282.32
05/23/2023​	(1.50)	59,280.82
05/23/2023​	(59.99)	59,220.83
05/23/2023​	(36.18)	59,184.65
05/23/2023​	(3.28)	59,181.37
05/23/2023​	(1.00)	59,180.37
05/23/2023​	(22.39)	59,157.98
05/23/2023​	(25.00)	59,132.98
05/23/2023​	(26.99)	59,105.99
05/23/2023​	(22.16)	59,083.83
05/23/2023​	(31.34)	59,052.49
05/23/2023​	(9.99)	59,042.50
05/23/2023​	(25.00)	59,017.50
05/23/2023​	(18.60)	58,998.90
05/24/2023​	(265.00)	58,733.90
05/24/2023​	(19.99)	58,713.91
05/25/2023​	(7.75)	58,706.16
05/25/2023​	(3.40)	58,702.76
05/25/2023​	(18.01)	58,684.75
05/25/2023​	(22.97)	58,661.78
05/25/2023​	(13.05)	58,648.73
05/25/2023​	(32.84)	58,615.89
05/25/2023​	(81.25)	58,534.64
05/26/2023​	(150.00)	58,384.64
05/26/2023​	(4.99)	58,379.65
05/26/2023​	(210.00)	58,169.65
05/27/2023​	10,000.00	68,169.65
05/27/2023​	(1.81)	68,167.84
05/27/2023​	(3.99)	68,163.85
05/27/2023​	(23.92)	68,139.93
05/27/2023​	(7.96)	68,131.97
05/31/2023​	(150.00)	67,981.97
05/31/2023​	(11.99)	67,969.98
05/31/2023​	(14.06)	67,955.92
05/31/2023​	(18.50)	67,937.42
05/31/2023​	(38.31)	67,899.11
05/31/2023​	(9.15)	67,889.96
05/31/2023​	(41.91)	67,848.05
05/31/2023​	(8.99)	67,839.06
05/31/2023​	(24.51)	67,814.55
05/31/2023​	(31.34)	67,783.21
05/31/2023​	(1.65)	67,781.56
05/31/2023​	(77.00)	67,704.56
05/31/2023​	(2.00)	67,702.56
05/31/2023​	(32.57)	67,669.99
05/31/2023​	(124.85)	67,545.14
05/31/2023​	(19.99)	67,525.15
05/31/2023​	(50.00)	67,475.15
05/31/2023​	(29.13)	67,446.02

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F
1
2	01/05/2023	10,126.27	10,126.27		01/05/2023	10126.27
3	02/05/2023	8.99	10,135.26		02/05/2023	10120.3
4	02/05/2023	-4.99	10,130.27		03/05/2023	10103.29
5	02/05/2023	-3.99	10,126.28		04/05/2023	10125.27
6	02/05/2023	-3.99	10,122.29		05/05/2023	10135.26
7	02/05/2023	-1.99	10,120.30		06/05/2023	10126.27
8	03/05/2023	4.99	10,125.29		07/05/2023	10126.27
9	03/05/2023	3.99	10,129.28		08/05/2023	10126.27
10	03/05/2023	3.99	10,133.27		09/05/2023	10114.3
11	03/05/2023	1.99	10,135.26		10/05/2023	10103.29
12	03/05/2023	-21.98	10,113.28		11/05/2023	10135.26
13	03/05/2023	-9.99	10,103.29		12/05/2023	10126.27
14	04/05/2023	21.98	10,125.27		13/05/2023	10129.28
15	04/05/2023	9.99	10,135.26		14/05/2023	10129.28
16	04/05/2023	-9.99	10,125.27		15/05/2023	10129.28
17	05/05/2023	9.99	10,135.26		16/05/2023	10093.3
18	06/05/2023	-8.99	10,126.27		17/05/2023	10135.26
19	09/05/2023	8.99	10,135.26		18/05/2023	61015.26
20	09/05/2023	-9.99	10,125.27		19/05/2023	59690.58
21	09/05/2023	-4.99	10,120.28		20/05/2023	59524.9
22	09/05/2023	-3.99	10,116.29		21/05/2023	59524.9
23	09/05/2023	-1.99	10,114.30		22/05/2023	59524.9
24	10/05/2023	9.99	10,124.29		23/05/2023	58998.9
25	10/05/2023	4.99	10,129.28		24/05/2023	58713.91
26	10/05/2023	3.99	10,133.27		25/05/2023	58534.64
27	10/05/2023	1.99	10,135.26		26/05/2023	58169.65
28	10/05/2023	-21.98	10,113.28		27/05/2023	68131.97
29	10/05/2023	-9.99	10,103.29		28/05/2023	68131.97
30	11/05/2023	21.98	10,125.27		29/05/2023	68131.97
31	11/05/2023	9.99	10,135.26		30/05/2023	68131.97
32	12/05/2023	-8.99	10,126.27		31/05/2023	67446.02
33	13/05/2023	8.99	10,135.26
34	13/05/2023	-3.99	10,131.27
35	13/05/2023	-1.99	10,129.28
36	16/05/2023	3.99	10,133.27
37	16/05/2023	1.99	10,135.26
38	16/05/2023	-21.98	10,113.28
39	16/05/2023	-9.99	10,103.29
40	16/05/2023	-9.99	10,093.30
41	17/05/2023	21.98	10,115.28
42	17/05/2023	9.99	10,125.27
43	17/05/2023	9.99	10,135.26
44	18/05/2023	50,000.00	60,135.26
45	18/05/2023	1,000.00	61,135.26
46	18/05/2023	-120	61,015.26
47	19/05/2023	-60	60,955.26
48	19/05/2023	-8.99	60,946.27
49	19/05/2023	-200	60,746.27
50	19/05/2023	-500	60,246.27
51	19/05/2023	-209.32	60,036.95
52	19/05/2023	-265	59,771.95
53	19/05/2023	-15	59,756.95
54	19/05/2023	-44.13	59,712.82
55	19/05/2023	-17.25	59,695.57
56	19/05/2023	-4.99	59,690.58
57	20/05/2023	-3.99	59,686.59
58	20/05/2023	-1.99	59,684.60
59	20/05/2023	-2	59,682.60
60	20/05/2023	-19.79	59,662.81
61	20/05/2023	-6.99	59,655.82
62	20/05/2023	-9.99	59,645.83
63	20/05/2023	-26.99	59,618.84
64	20/05/2023	-25	59,593.84
65	20/05/2023	-7.99	59,585.85
66	20/05/2023	-9.99	59,575.86
67	20/05/2023	-3.99	59,571.87
68	20/05/2023	-8.99	59,562.88
69	20/05/2023	-2.99	59,559.89
70	20/05/2023	-11.99	59,547.90
71	20/05/2023	-17	59,530.90
72	20/05/2023	-6	59,524.90
73	23/05/2023	-21.98	59,502.92
74	23/05/2023	-9.99	59,492.93
75	23/05/2023	-1.72	59,491.21
76	23/05/2023	-30	59,461.21
77	23/05/2023	-19.93	59,441.28
78	23/05/2023	-158.96	59,282.32
79	23/05/2023	-1.5	59,280.82
80	23/05/2023	-59.99	59,220.83
81	23/05/2023	-36.18	59,184.65
82	23/05/2023	-3.28	59,181.37
83	23/05/2023	-1	59,180.37
84	23/05/2023	-22.39	59,157.98
85	23/05/2023	-25	59,132.98
86	23/05/2023	-26.99	59,105.99
87	23/05/2023	-22.16	59,083.83
88	23/05/2023	-31.34	59,052.49
89	23/05/2023	-9.99	59,042.50
90	23/05/2023	-25	59,017.50
91	23/05/2023	-18.6	58,998.90
92	24/05/2023	-265	58,733.90
93	24/05/2023	-19.99	58,713.91
94	25/05/2023	-7.75	58,706.16
95	25/05/2023	-3.4	58,702.76
96	25/05/2023	-18.01	58,684.75
97	25/05/2023	-22.97	58,661.78
98	25/05/2023	-13.05	58,648.73
99	25/05/2023	-32.84	58,615.89
100	25/05/2023	-81.25	58,534.64
101	26/05/2023	-150	58,384.64
102	26/05/2023	-4.99	58,379.65
103	26/05/2023	-210	58,169.65
104	27/05/2023	10,000.00	68,169.65
105	27/05/2023	-1.81	68,167.84
106	27/05/2023	-3.99	68,163.85
107	27/05/2023	-23.92	68,139.93
108	27/05/2023	-7.96	68,131.97
109	31/05/2023	-150	67,981.97
110	31/05/2023	-11.99	67,969.98
111	31/05/2023	-14.06	67,955.92
112	31/05/2023	-18.5	67,937.42
113	31/05/2023	-38.31	67,899.11
114	31/05/2023	-9.15	67,889.96
115	31/05/2023	-41.91	67,848.05
116	31/05/2023	-8.99	67,839.06
117	31/05/2023	-24.51	67,814.55
118	31/05/2023	-31.34	67,783.21
119	31/05/2023	-1.65	67,781.56
120	31/05/2023	-77	67,704.56
121	31/05/2023	-2	67,702.56
122	31/05/2023	-32.57	67,669.99
123	31/05/2023	-124.85	67,545.14
124	31/05/2023	-19.99	67,525.15
125	31/05/2023	-50	67,475.15
126	31/05/2023	-29.13	67,446.02
Sheet6

Cell Formulas
Range	Formula
F2:F32	F2	=LOOKUP(E2,$A$2:$A$200,$C$2:$C$200)

 

[Joe4]

If the data you posted is in range A2:C126, and your dates start in cell E2, enter this formula in F2 and copy down:

=IFERROR(XLOOKUP(E2,A$2:A$126,C$2:C$126,,,-1),F1)