Combining UNIQUE with COUNTA allows you to count the number of unique entries in a dataset. Dynamic array formulas in Excel 365 enhance the flexibility and efficiency of the UNIQUE function.

However, things get a little more intricate if your column contains text entries. If you were to use the above function combination for this, it would only count the rows that feature numbers.