When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

The UNIQUE function can become even more powerful when combined with other Excel functions. Let’s do an example where we will use the UNIQUE function to create a list of unique customers, as we did ...

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.