How to Saving Common Formulas
[Excel: Excel Formulas]
Summary: Assign the formula a name, just like you can with cell ranges and use it over and over again. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
How to Ignoring N/A Values in a Sum
[Excel: Excel Formulas]
Summary: On a summary worksheet you want to sum the values but ignoring #N/A values. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Finding The First Non-Digit Position
[Excel: Formulas]
Summary: How to find out where the digits stop and the non-digits begin in a string of text that is composed of digits and non-digits. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
How to Determining "Highest Since" or "Lowest Since"
[Excel: Formulas]
Summary: Analyzes the latest houses sold data, and needs to write a report about the data. For example "The number of houses sold was the lowest since Jan 1989". Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Paste Special a Formula
[Excel: Macros]
Summary: For example, you may have the value of 10 in cell A3 to A 10, and you want to increase it by 20%. Using Paste Special you can easily change it to 120, but you may instead want to replace the value with the formula =100*1.2. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
[ Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Next ]
