copy a range without the same value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top