If you are looking for an easy way to enhance your Excel data analysis and visualizations you might be interested in learning more about the Filter feature available within Microsoft Excel ...
MUO on MSN
Excel's dynamic array functions made me realize I'd been solving problems the hard way for years
Turns out half my old formulas were just dynamic arrays in disguise, written the long way.
Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data matching your specified criteria.
and only files matching my_test_here would make it onto do_something. I love the while-read pattern, but it just doesn't feel right that there's no simpler, built-in, idiomatic way to write a function ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results