Forum Discussion
Formula not working for me
Hello,
I have a task at work in Excel and it's driving me crazy. I have 96,000 rows of text ( names of files from a hard drive) and I have to check if any of them contain a year from 2000 to 2009 in their name, so I have thought about searching " 200 " to check every year. There are files named "File2008", "File2001.old" and so on. I have tried using multiple formulas "=ISTEXT(SEARCH("200", A2)) ", "=IF(ISNUMBER(SEARCH("200",A2)) and others, but none of them work ( I get an error "We found a problem with this formula" ). Can anyone please help me? I have no idea what the formula should be for my task. I have watched a few videos about these, but somehow none of them work for me.
- Can't you use the autofilter feature for this? Then you can just type 200 in the filter search box, Excel will hide everything that doesn't contain 200.
6 Replies
Specifically, this is what JKPieterse was referring to:
Alternatively, this formula in B2 of the attached file returns TRUE if the FileName contains 200, as shown in the snapshot below:
- It worked. Thanks!
Direct filtering as JKPieterse suggested is more logical, but if you need formula for some purposes it will be as
=IF(ISNUMBER(SEARCH("200",A2)),A2,"")- I did the filtering and it worked. Thanks!:)
- Can't you use the autofilter feature for this? Then you can just type 200 in the filter search box, Excel will hide everything that doesn't contain 200.
JKPieterseYeah, that seems easier. It worked. Thank you! 🙂
