How to use the UNIQUE() function in Excel. If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE() function.

Setting up this formula shouldn't take more than a few moments, and Excel will be able to immediately tally each use of that phrase. Note the cell range that you need to make the phrase count ...

Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, today, Excel's LAMBDA tool lets you do this using familiar Excel language ...

2. From the Formulas tab, click Define Name.. 3. Notice that Excel has already entered the column/field name of the range you highlighted (even though that cell was not included in your range).