Microsoft Excel’s new import functions make handling numbers easier

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it ...
How-To Geek on MSN

Excel LAMBDA vs. SCAN: What's the difference and how do they work together?

LAMBDA defines the custom logic, and SCAN moves that logic through your data range.