These new formulas are being rolled out to Office 365 subscribers over the next few months. Just add more conditions to the SUMPRODUCT formula and it will reveal all your. 1 In the above formula A2A7 is the range containing the names you want to count.
A Duplicate Values dialog box will pop up.
Select the H ighlight Cells Rules option and from the secondary menu that appears select the D uplicate Values. Select the Cell B2. Enter the below formula into it and press the Enter key to get the result. Write the formula to retrieve the unique values from a list.