Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it easier to refresh and reuse frequently updated data inside a worksheet. The ...
How-To Geek on MSN
How to use formula by example in Excel to generate complex formulas
I traded the static results of Flash Fill for dynamic formulas that update automatically.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results