Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References in Excel

In this article we'll learn how to copy formulas in Excel without changing the cell reference or in simple words we can say that how to copy exact for...

Removing duplicate values by comparing values in two consecutive columns

  In this article, we will create a macro to check duplication and remove duplicate values from two consecutive columns. Raw data consists of t...

Randomly Selecting a Value from a Range

Problem: Randomly selecting one of the letters from the range A1:C4. Solution: Use the INDEX and RANDBETWEEN functions in the following formu...

Selecting Cells That Contain Errors in Formulas in Excel 2007

To select cells containing errors in Formulas: Select Home -> Find & Select (in Editing Group) -> Go To Special -> Formulas -> Erro...

Setting Excel To Calculate Manually

By default Excel will automatically calculate any formula that you type in or insert into it. That’s what you want it to do right?.  Most times yes...

ARABIC function

Excel 2013 has given us a function which converts a Roman number to an Arabic number. For example, if you wish to convert the Roman number ("XII") ...

Extracting last Word

Problem: Creating a formula to retrieve the last word from a string Solution: Using the MID, FIND, SUBSTITUTE and LEN text category functions, ...

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