Dynamic categories

One of the earlier “recipes” mentioned categories and subcategories. If you remember, we wanted to make it possible to automatically create a list with a selection of subcategories by selecting a category from the list generated with Data Validation. We could have done this by applying a few tricks, but the list, in addition to the necessary values, contained “empty slots”. This can be easily avoided today with the help of dynamic arrays.

UNIQUE function

Sometimes you have repeating values ​​in the column and you want to extract only their unique instances. The Remove Duplicates option is used to do this, and the UNIQUE is a new Excel function that has been built to perform the same thing. It generates a dynamic array with unique values, whether it contains text, numbers, dates …