If you do, Excel will give you a circular reference warning. Type this function in the cell, including the quotation marks but excluding the final period: =COUNTIF (cell range, "phrase").

If the text in cells A1 or A2 already has double quotation marks surrounding it, the marks would be included in the result. If you need to add these marks, you can do so with a special character code.

Figure B 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.

You can save time by creating an AutoFill series in Excel 2003 as follows: Enter the values and then select the list. Choose Options from the Tools menu. Click the Custom Lists tab. Click Import.