Advanced Filter

Use the new FILTER() formula and retrieve only the columns you want

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 it seemed like you could only return ALL the columns in the range you are …

Use the new FILTER() formula and retrieve only the columns you want Read More »

Save time using Excel Templates to upload to your accounting software – Part B Using Autofilter for bank entries

VBA, Accounting Software, Applications, Automation, Automation Page Posts, Data Cleaning, Data Manipulation, Excel Automation

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. In my case it was to record bank transfers from my cheque account to an interest …

Save time using Excel Templates to upload to your accounting software – Part B Using Autofilter for bank entries Read More »