Hi all,

I have a range of value such as 1, 1, 2, 3, 6, 6, 8 etc....I want to copy it
to an other worksheet but i do not want to see the two 1s, and the two 6s i
want the result to be 1, 2, 3, 6, 8 etc...

thanks a lot for your help