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

How to Count values meeting multiple criteria in different columns in Excel

In this article, we will learn How to Count values meeting multiple criteria in different columns in Excel. Scenario: In Excel, we sometimes...

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 row Order Of Values In A List in Excel

In this article, we will learn How to use the ... function in Excel. Scenario : In Excel, you can sort values in ascending or descending. Bu...

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.