Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copy a range without the same value
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to copy last positive number in range of cells | Excel Worksheet Functions | |||
Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
Copy a range | Excel Worksheet Functions | |||
copy range of cells from one workbook to another | Excel Discussion (Misc queries) |