Forum Discussion
Find and Replace Multiple Data Points (Or aDifferent Solution?)
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.
HansVogelaar Thanks, Hans. I appreciate the help.
When you say, "Select the list with the 350 names." Currently, that list is in a txt file.
Should it be added to the sheet I am working on? In the same tab?
When you say, "Click in the address box on the left-hand side of the formula bar."
I'm not sure what you mean.
I think I know what the formula bar is, but I can't find the address box.
This is what I am currently looking at:
Where do I find theaddress box?
Copy the list of names into a range on a worksheet - it can be the sheet with the data, or another sheet in the same workbook. That doesn't matter.
Thanks Hans.
I got it working somewhat, but it seems to throw up many false positives.
If you look at this image (sorry for the content; I'm trying to remove spam links from a client's site).
You can see the first two rows worked as they should have.
When I scroll down the sheet, a lot of values say TRUE when I dont think they should.
You can see the example in the image:I have manually searched column E and A13 should not be listed as true.
I am not sure what I am doing wrong?Are you sure that datissamaneh.ir (or part of it, for example amaneh.ir) is not in your list of spam domains?
