Coach Andrew
New member
- Joined
- Jun 24, 2021
- Messages
- 20
- Reaction score
- 0
- Points
- 0
- Location
- Ottawa
- Excel Version(s)
- Excel 2016
Trying to figure out a formula to help reconcile clearing account with over 5K lines of data each month.
Currently it is a manual process of using ABS formula and colour coding entries that offset, example $100 with -$100 = Zero.
It takes about 4 hours to be this each month and was thinking there must be a better way.
Any ideas?
Currently it is a manual process of using ABS formula and colour coding entries that offset, example $100 with -$100 = Zero.
It takes about 4 hours to be this each month and was thinking there must be a better way.
Any ideas?