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 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 ...

Counting values meeting multiple criteria in different columns

Problem: Counting the number of "red" items which cost less than $1000. Solution: Using the SUMPRODUCT function to count the number of items ...

Copying a Formula from a Cell While Keeping the Reference in Excel 2007

Avoid the nightmare of toggling through the combinations of the F4 key when coping and pasting formulas. To copy/paste a Formula without keeping th...

Count filtered cells using SUBTOTAL

Here's what might be one of the most versatile formulae in (almost) common usage. I made a similar posting in March but only from a COUNTA point of...

Stepping into a Formula in Excel 2007

To step into a Formula:  Select Formulas -> Evaluate Formula (in Formula Auditing Group). The Evaluate Formula dialog box allows moving betwee...

Reversing The Order Of Values In A List

Problem: We want to rearrange the contents of the list in column A in reverse order. Solution: Use the OFFSET, COUNTA, and ROW functions as s...

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