Chapter 2. Natural Language Range Names
How do I create a name for a range of cells based on a spreadsheet label and use that name in formulas?
How do I use natural language range names to incorporate a relationship such as Month(t) Ending Inventory = Month(t) Beginning Inventory + Month(t) Production –Month(t) Demand in a spread-sheet formula?
Microsoft Excel 2002 and Microsoft Office Excel 2003 give you the ability to create "natural language" range names based on labels already present in your spreadsheet. I’ll illustrate the use of natural language range names with two examples.
Note
This feature is available only in Excel 2002 and Excel 2003.
How do I create a name for a range of cells based on a spreadsheet label and use that name in formulas? ...
Get Microsoft® Excel Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
