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

Stay tuned There are several new dynamic array functions and over the next few months, we’ll cover several of them. Next up, we’ll be using SEQUENCE () to return the top n values in a data set.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...