Forum Discussion
TimMarston
Dec 18, 2023Copper Contributor
Find and Replace Multiple Data Points (Or aDifferent Solution?)
Hi I am using Microsoft Excel for Mac and am stumped with a problem. I have a sheet with one column that has 340,000 rows of data. I have a list of 350 names that I want to search the first ...
TimMarston
Copper Contributor
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?
HansVogelaar
Dec 18, 2023MVP
Are you sure that datissamaneh.ir (or part of it, for example amaneh.ir) is not in your list of spam domains?