Forum Discussion
Find and Replace Multiple Data Points (Or aDifferent Solution?)
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?