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

MUNIT function

MUNIT function Munit function has been introduced with Excel 2013.  It returns the unit matrix for the specifid dimension. For example, you can ...

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