Posts

Showing posts with the label Excel

Count Distinct in Excel

To count the distinct value of a list of data, you can try the following functions (Assume the data are in A1:A30000, you cannot use A:A in this function): =SUMPRODUCT((A1:A30000<>"")/COUNTIF(A1:A30000,A1:A30000&""))
Post a Comment
Read more