compare columns and remove both instances of duplicates

's Computer Specifications

i have a new list and older version. I need to know only the values
that are new. Duplicate finder only deletes one copy of a duplicate
value i want to delete both, is there a way to do this?
thanks

's Computer Specifications

Do you mean if your new list is in column A and your old list is in column
B, you want to delete all items in column B that also appear in column A?
James
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>i have a new list and older version. I need to know only the values
> that are new. Duplicate finder only deletes one copy of a duplicate
> value i want to delete both, is there a way to do this?
> thanks
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Compare columns for duplicates	acab	Microsoft Excel New Users	2	3rd Oct 2008 08:14 AM
How to compare two columns and remove duplicates?	username123	Microsoft Excel Misc	15	5th Jul 2006 04:06 PM
Compare the 1st 9 digits in two columns looking for duplicates	=?Utf-8?B?U3dlZXRldGM=?=	Microsoft Excel Worksheet Functions	9	26th Mar 2006 11:58 PM
how do i compare two columns and remove duplicates?	=?Utf-8?B?YWxqZXJub244MDU=?=	Microsoft Excel New Users	1	9th Dec 2005 04:04 PM
compare two columns and remove duplicates	=?Utf-8?B?TW9uaTM5?=	Microsoft Excel Worksheet Functions	3	5th May 2005 06:08 PM