Here's one way.
With your list of numbers in A1:A36 use this formula in C2
=IF(ROWS(C$1:C1)>COUNT(1/FREQUENCY(A$1:A$36,A$1:A$36)),"",MIN(IF(ISNA( MATCH(A$1:A$36,C$1:C1,0)),A$1:A$36)))
confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar
and in D2
=IF(C2="","",COUNTIF(A$1:A$36,C2))
copy both formulas down as far as required
column C gives you a unique list of all numbers in the range and column D the count
Bookmarks