A Special Paste Funtion

[Jay]

I was once able to copy a lot of data that was contained
in about 12 Columns and 2000 rows. I was then able to use
a special paste function that automaticlly deleted
duplicate records and pasted only the ones that were
unique. Any Ideas?
Thank you
Jay

 

[Debra Dalgleish]

You can use Advanced Filter to extract unique items from a list. There
are instructions here:

http://www.contextures.com/xladvfilter01.html#FilterUR

 

[Jay]

That's the one. Thank You

-----Original Message-----
You can use Advanced Filter to extract unique items from a list. There
are instructions here:

http://www.contextures.com/xladvfilter01.html#FilterUR



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.