With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, December 6, 2011
yogi_Compute Running Balances For Transactions In Date Descending Order
Yogi Anand, D.Eng, P.E.Google Spreadsheet www.energyefficientbuild.com user brder said: Create an ArrayFormula for a Date Descending Running Balance I have searched this extensively and have not found an answer. I have a simple sheet for tracking bank transactions. The columns (left to right) are
Date | Transaction | Amount | Balance.Like any banking website, the transactions are date descending (e.g. newest at the top). So to keep the balance requires some trickery. I have the following formula which appears to work.