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.