how to find number of distinct values in a column in excel?
['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.']