Question: how to find number of distinct values in a column in excel?
Answer: Select the range of cells, or make sure the active cell is in a table. ...  On the Data tab, in the Sort & Filter group, click Advanced. ...  Click Copy to another location. In the Copy to box, enter a cell reference. ...  Select the Unique records only check box, and click OK.