INDEX

Using Excel Templates to upload to an accounting software – Part A The Cash Book

I have been putting off blogging about this topic because it’s unwieldy to explain and involves work done many years ago that I would do better now.   I cringe a bit seeing an Offset formula now which I would only use these days as a last resort because it’s volatile.  But let’s see if it …

Using Excel Templates to upload to an accounting software – Part A The Cash Book Read More »

No more gaps – a formula to remove spaces in lists or empty rows in ranges

Update 12/12/2021 Since writing this post in 2017, Excel now has new revolutionary dynamic array formulas that really has overtaken all the workarounds for better dropdown lists we used to do such as described in my post below.  Now the new formula SORT() + UNIQUE() in Excel Office 365 (although not in earlier stand alone …

No more gaps – a formula to remove spaces in lists or empty rows in ranges Read More »