### Quickly sum non-contiguous cells

Sometimes you may want to calculate the sum of a group of non-continuous or non-contiguous cells.  Do you enter in each cell address like =A2+C2+G2+I...

### Iteration in Excel 2007

To intentionally use a Circular Reference: In this example, a Value-added tax (VAT) gross-up formula is in cell B1 (the formula is =B3-B2). 1. In ...

### How to use the BITLSHIFT Function in Excel

IN this article, we will understand How to use the BITLSHIFT Function in Excel Scenario: This function was introduced in Excel 2013 and it r...

### How to use the BITXOR Function in Excel

In this article, we will learn about how to use the BITXOR function in Excel. Scenario: BITXOR function in excel perform the BITWISE XOR ope...

### How to use the XOR function in Excel

In this article, we will learn about how to use the XOR function in Excel. In simple words, logic_test are performed in excel to perform an action ...

### How to Delete Range Name in Excel

In Microsoft Excel if you want to remove named range, it is a very simple task. First, let’s create a Name Range so that we can understand it in a b...

### Finding a substring within a string

Problem: Determining whether the strings in column C contain the corresponding substrings in column D. Solution 1: Using the COUNTIF function in ...

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.