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.
JKPieterse's avatar
JKPieterse
Silver Contributor
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.
  • Edward__'s avatar
    Edward__
    Copper Contributor
    Jan 14, 2020

    JKPieterseYeah, that seems easier. It worked. Thank you! 🙂

Resources