antoine

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formula to copy last positive number in range of cells	rolan	Excel Worksheet Functions	6	May 14th 05 02:27 PM
Copy cells into range of cells until cell change	mdeanda	Excel Worksheet Functions	1	April 22nd 05 08:41 PM
Define a range based on another named range	Basil	Excel Worksheet Functions	2	February 21st 05 01:47 PM
Copy a range	GrantM	Excel Worksheet Functions	1	December 21st 04 09:59 AM
copy range of cells from one workbook to another	mitmeez	Excel Discussion (Misc queries)	1	December 9th 04 08:14 PM

All times are GMT +1. The time now is 10:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us