Multiple Item Replace???

[Guest]

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]

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

 

[Guest]

Great! Thanks alot!

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