Nested IF statements used to be my go-to whenever I needed to juggle multiple conditions in Excel. However, just because they get the job done doesn’t mean they’re the best tool for the job. Wrestling ...

Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions. In many cases, they can replace older, more complex expressions. The new functions do all that ...

Microsoft has recently added a new feature to excel in the form of the extremely useful Scan Function. This guide aims to provide a quick overview of how you can get the most from this new function ...

How to use the FILTER() dynamic array function in Excel Your email has been sent Filtering is a huge part of many Microsoft Excel sheets, and fortunately, there are ...