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):



Popular posts from this blog

Post packing slip of sales order in X++

Ctrl, Alt or Shift button of Type Cover 2 are getting stuck