Tag: Advanced Filter

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 »

Tagged with: ,

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.  …

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

Tagged with: , ,