NeedExcelHelp2021
New Member
- Joined
- Apr 17, 2021
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
I have a lot of cells so a formula that can do this would be a great help, and can you make it work on filtered cells Thank You.
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | 2009 | $ 10,000 | Year | Start Balance | End Balance | |||||
2 | 2009 | $ 15,000 | 2009 | $ 10,000 | $ 30,000 | |||||
3 | 2009 | $ 20,000 | 2010 | $ 35,000 | $ 50,000 | |||||
4 | 2009 | $ 40,000 | 2011 | $ 70,000 | $ 105,000 | |||||
5 | 2009 | $ 30,000 | ||||||||
6 | 2010 | $ 35,000 | ||||||||
7 | 2010 | $ 40,000 | ||||||||
8 | 2010 | $ 45,000 | ||||||||
9 | 2010 | $ 50,000 | ||||||||
10 | 2010 | $ 60,000 | ||||||||
11 | 2010 | $ 55,000 | ||||||||
12 | 2010 | $ 50,000 | ||||||||
13 | 2011 | $ 70,000 | ||||||||
14 | 2011 | $ 75,000 | ||||||||
15 | 2011 | $ 80,000 | ||||||||
16 | 2011 | $ 85,000 | ||||||||
17 | 2011 | $ 160,000 | ||||||||
18 | 2011 | $ 150,000 | ||||||||
19 | 2011 | $ 100,000 | ||||||||
20 | 2011 | $ 105,000 | ||||||||
21 | ||||||||||
22 | ||||||||||
23 | ||||||||||
Sheet1 |