Find and Replace Multiple Data Points (Or aDifferent Solution?)

TimMarston

Select the list with the 350 names.

Click in the address box on the left hand side of the formula bar.

Type a name such as List then press Enter.

Let's say your data are in A2 and down.

In an empty column (insert one if necessary), enter the following formula in the cell in row 2:

=OR(ISNUMBER(SEARCH(List, A2)))

Fill down to the last used row. If the data column doesn't contain blank cells, the easiest way to do that is to double-click the fill handle in the lower right corner of the cell with the formula.

You'll now have a column with TRUE/FALSE values - TRUE if the cell in column A contains at least one of the names from the list, FALSE otherwise.

Filter the column to display only the TRUE values.

Select all visible rows from row 2 down, then delete them.

Finally, turn the filter off.