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

BITOR function

In this article, we will learn about how to use the BITOR function in Excel. BITOR function in excel perform the Bitwise OR operation between the t...

UNICODE function

In this article, we will learn about how to use the UNICODE function in Excel. Unicode is computing standard for the unified encoding, representation...

IFERROR Function - New Function in Excel 2007

In this article, we will learn where and how we can use Excel formula IFERROR. What is IFERROR function? The IFERROR function Returns a value you sp...

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 Youtube