Lists as function arguments

Excel has recently made it easier to work with formulas that use arrays and constants – you no longer have to save them by pressing CTRL+SHIFT+ENTER! We can now use lists of values, given in curly brackets, as function arguments. This is great news, and the possibilities are manifold. In the following post, you will be able to see the real application of this feature…

Dynamic lists, the easy way

There are several ways to use the Data Validation option  to generate lists to select values when filling out tables. One of the earlier “recipes” was about how to create dynamic lists. With the advent of the TRIMRANGE function, this can now be done in an even simpler way, without having to use a Name Manager and write complicated formulas.