Forum Discussion
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 ...
=SUM(N(ISNUMBER(SEARCH($F$1:$F$4,A1))))
You can apply this formula in the small example. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
The range of the formula can be changed according to your requirement e.g.
=SUM(N(ISNUMBER(SEARCH($F$1:$F$350,A1))))
After applying the formula you can filter columns A and B and delete all rows where column B is greater 0. Then you can remove the filter. The remaining rows don't contain a name from the list of 350 names.
