Tuesday, October 26, 2010

Dynamic Named Ranges in Excel the classic way...

In Excel 2007 forwards, lists that expand and contract needed OFFSET calculation. Now with the new Tables feature, we don't have to use this old method.

in reference to: Dynamic Named Ranges That Expand and Contract Automatically in Your Excel Spreadsheet (view on Google Sidewiki)

No comments: