Forum Discussion

Edward__'s avatar
Edward__
Copper Contributor
Jan 14, 2020
Solved

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...
excel
Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    Jan 14, 2020
    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.
Twifoo's avatar
Twifoo
Silver Contributor
Jan 14, 2020

Edward__ 

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: 

 

 

 

  • Edward__'s avatar
    Edward__
    Copper Contributor
    Jan 14, 2020
    It worked. Thanks!

Resources