So in my previous post I was banging on about the new Dynamic Array formulas only fairly recently released to Office 365 Excel. I reckon FILTER() is the star but as I used it, I became a little disappointed as …
Use new FILTER() formula and retrieve only the columns you want Read More »
JohnHackwood
Posted in Accounting Software, Applications, Automation, Data Cleaning, Data Manipulation, VBA
OK so this post is the 2nd part of my recent post on how Excel can automate data entry to your accounting system. See here for Part A. This example concerns automating entries on your bank statement you can reliably identify. …