Excel Forum
Similar Content
Dynamic Named Range in Excel
Tutorial: How to create a named range that expands automatically when a new value is added to the r...
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...



Excel Name Trick #9: Create Name Formulas


See how to create name formulas that can be then used in cells.

1) See how to create a dynamic range using a named formula that uses the OFFSET function.
2) See how to create a named formula that will randomly create sales figures between an upper and lower value.
3) See how to store a tax rate constant in a name.

This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).





Got a Question? Ask it Here in the Forum.