Hi Antoine

Here's one way to do it.

Range of values in Sheet1 and sheets to copy to: Sheet2

1. Set an arbitrary heading in the cell above the list
2. Go to sheet2, select a cell and choose Data Filter Advanced
filter.
3. Check the box "Copy to another range" (or similar)
4. Choose the list
5. Leave the criteria field empty
6. Select a receiving cell in sheet2.
7. Check the box "Uniques only" (or similar). OK

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"antoine" skrev i en meddelelse
...
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