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 |
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 |
All times are GMT +1. The time now is 09:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com