How do people usually search in Excel? Mostly, by using the Find & Replace tool, which works just fine for single values. But what if you have tens or even hundreds of items to replace? Luckily, there are a few more effective methods to perform mass replace in Excel, and we are going to look at each of them in detail. Continue reading
With the introduction of the LAMBDA function, recursive computations in Excel have become available to anyone, not just VBA programmers. To put it simply, you can now construct formulas that behave like a programming language and allow you to achieve so much, with so little, so fast :) Continue reading
Until recently, user-defined functions were the prerogative of programmers. The introduction of the LAMBDA function has made them available for everyone. With this wonderful addition to Excel's toolbox, we no longer need VBA skills to create our own custom functions. Continue reading
