In Excel 365 and Excel 2021 Microsoft has provided Excel users with some new features which will fundamentally change the way worksheets are designed. Dynamic array formulas allow you to work with multiple values at the same time in a formula. Dynamic arrays solve some challenging difficulties in Excel and will be a feature which […]
I used to work with a colleague who maintained a postal mailing list for a brochure we would send out. He used to spend some of his time cleaning up that list by removing repeat entries of customer email addresses who had signed up more than once. “De-duping” he called it. He would block out […]
I use timings in worksheets alongside other key data, for example, in a project sheet, I have lists of individual tasks, with time started, time ended, total time taken, and then cost based on time taken multiplied by charge etc. So when I want to calculate a mixture of times multiplied by costs, I get an […]
Excel 2007 introduced the function COUNTIFS to count cells based on multiple criteria. For example suppose you wish to count how many times the client Fowler buys more than 250 shares. The answer for tha data below turns out to be 2 using the Countifs function entered in B13. Similarly for Owen the result turns out to be 1. […]