Unduplicated nos.

Dear sir,with best regards,i need your help to create a list in range (g5:g100) for unduplicated nos.which were in range (c5:c1000),for example,i have in column (c) nos.such as (1,1,1,1,2,3,3,3,4,4,5,6,6,6,6,7,7,8,9,15,15)
and the list i need is (1,2,3,4,5,6,7,8,9,15,----).
Many thanks in advance.

Hi Tomi

In Range A1:A10, are your Numbers. So in Column B try this formula(CFE). It's an Array Formula.

=SMALL(IF(FREQUENCY(IF($A$1:$A$10<>"";MATCH($A$1:$A$10;$A$1:$A$10;0));ROW($A$1:$A$10)-ROW($A$1)+1);$A$1:$A$10);ROWS($A$1:$A1))

Hope to helps you.