Using table:
B2
1
2
2
4
5
6
7
The following formula works, but what does the >0,1 at the end of
the formula mean
sum(if(frequency(b2:b8,,b2:b8)>0,1))