I have a list of data that I want to delete from another list. Too much to
do manually. Is there a way to do this with find and replace or another way?
Any help would be much appriciated.

You could do something like this:

Insert a helper column adjacent to the list that needs to be cleaned up. Say
the list to be cleaned up is in column A of sheet1 and you inserted a new column
B in Sheet1.

Then use a formula like:

=isnumber(match(a1,sheet2!a:a,0))

Where sheet2!a:a contains the list of items to delete.

drag that formula down.

Trues will show the ones that matched. Falses mean it didn't match.

Apply data|filter|autofilter to column B and show only the Trues.
delete those visible rows.

Chip Pearson has lots of ways to work with duplicates/uniques at:
http://www.cpearson.com/excel/duplicat.htm

Frank wrote:

I have a list of data that I want to delete from another list. Too much to
do manually. Is there a way to do this with find and replace or another way?
Any help would be much appriciated.

--

Dave Peterson

Great! Thanks alot!

"Dave Peterson" wrote:

You could do something like this:

Insert a helper column adjacent to the list that needs to be cleaned up. Say
the list to be cleaned up is in column A of sheet1 and you inserted a new column
B in Sheet1.

Then use a formula like:

=isnumber(match(a1,sheet2!a:a,0))

Where sheet2!a:a contains the list of items to delete.

drag that formula down.

Trues will show the ones that matched. Falses mean it didn't match.

Apply data|filter|autofilter to column B and show only the Trues.
delete those visible rows.

Chip Pearson has lots of ways to work with duplicates/uniques at:
http://www.cpearson.com/excel/duplicat.htm

Frank wrote:

I have a list of data that I want to delete from another list. Too much to
do manually. Is there a way to do this with find and replace or another way?
Any help would be much appriciated.

--

Dave Peterson