Selecting Cells That Contain Formulas in Excel 2007

To select cells containing Formulas only:  Select Home -> Find & Select (in Editing Group) -> Formulas. Or Use the Go To dialog box: ...

Rounding Numbers that Meet Specified Criteria

Problem: Rounding all the numbers in column A to zero decimal places, except for those that have "5" in the first decimal place. Solution: Us...

Nesting OR and AND Functions to Meet Multiple Criteria

Problem: We want to check whether or not each value in List1 (column A) meets both of the following criteria: 1. The number must be even. 2. The ...

Icons Disappearing from the Toolbar

Troubleshooting: When adding new icons to the Standard and Formatting toolbars, some of the existing icons may disappear. This happens because there a...

Forecasting Daily Budget

Tip submitted by: Matt, San Diego, CA Place todays date in cell A1, press Ctrl+; Example: 3/9/2005 Place a dollar amount in cell A2: 500.00...

Finding the Largest Value from Two Different Lists, Subject to Specified Criteria

Problem: Columns A & B contain two lists of numbers. We want to create a formula that will return the maximum value from either list, providing th...

Finding the Largest Number among Those Meeting Specified Criteria

Problem: Column A contains 5-digit numbers. We want to find the largest number from the list whose first two digits are "11". Solution: Use ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube