Here is a picture of the closed workbook. There can´t be any blank cells or text values in your range.
As you can see, there are five unique distinct values (1, 2, 3, 5 and 6) and one duplicate value (3).
How to count unique and duplicate numbers from a closed workbook
Formula in B1:
Don´t forget to change path to your closed workbbook.
Formula in B2:
Don´t forget to change path to your closed workbbook
If I try to evaluate formula I get som strange results. A lot of #ref errors but the final result is correct.
Functions in this article:
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
Adds all the numbers in a range of cells
Calculates how often values occur within a range of values and then returns a vertical array of numbers having one more element than Bins_array.