- Remove Leading and Trailing Spaces
- Your Lookup Table Can Go Across
- Copy a VLOOKUP Across Many Columns
- INDEX Sounds Like an Inane Function
- You Already Know MATCH, Really!
- INDEX Sounds Like an Inane Function - II
- VLOOKUP Left
- Fast Multi-Column VLOOKUP
- VLOOKUP
- Return the Next Larger Value in a Lookup
- Two-Way Lookup
- Combine Formulas into a Mega-Formula
- Combine Two Lists Using VLOOKUP
- Watch for Duplicates When Using VLOOKUP
-
- Return the Last Entry
- Return the Last Matching Value
- Sum All of the Lookups
- Embed a Small Lookup Table In Formula
- I Don't Want to Use a Lookup Table to Choose One of Five Choices
- Lookup Two Values
- Add Comments to a Formula
- Create Random Numbers
- Randomly Sequence a List
- Play Dice Games with Excel
-
- Generate Random Without Repeats
- Calculate a Moving Average
- Calculate a Trendline Forecast
- Build a Model to Predict Sales Based on Multiple Regression
- Measure the Accuracy of a Sales Forecast
- Switching Columns into Rows Using a Formula
- SUM a Range that is C5 Rows Tall
- Whatever Happened to the @@ Function?
- Tables Are Like a Database in Excel
- Dealing with Table Formulas
- Rename Your Tables
- Charts , VLOOKUP & Pivots Expand With The Table
- Find out if Other Cells Rely on It
- Calculate a Formula in Slow Motion
- Which Cells Flow into This Cell?
- Color all Precedents or Dependents
MORE RESOURCES
FOR MICROSOFT EXCEL
