# Tag Archives: Formulas

## How Do You UNSORT Data in Excel?

The sorting feature of Excel is very useful to organize and put data into a structured format. But many times, we think of a better way to do it — only after we complete the data sorting! So somehow we have to revert the sorting

## Cross Products with Excel and VBA

Microsoft Excel does not have the built-in worksheet functions to calculate the cross product of two vectors. Therefore, some techniques are required to do the calculation — either by setting up your own formula in a worksheet or by creating a custom VBA function. The

## Using VBA Sum and VBA Sum Range

The Sum function in Excel is one of the most widely used functions, and in fact, probably one of the first functions that an Excel user learns when they are learning to use Excel!  Simply stated, the Sum function adds up a range of cells for

## Rounding with VBA and Excel: Functions and Gotchas

VBA is often used for calculations – when you create these calculations, you can end up with a number that has multitude of decimal places.  The Round function in VBA lets you round the number to a set amount of decimal points, or to remove

## Excel, Functions and Formulas, Tutorial / Sample, Text and Strings #2 (Advanced)

Today when I was looking through the stackoverflow forum, I came up to this question: vba-clean-up-conditional-duplication-of-rows Though the question was actually VBA related I was able to find a solution that did not require any programming. Since the solution was challenging and interesting I thought

## Excel Functions and Formulas, CHAR()

Each character is mapped to a numeric value. For example the character “A” is mapped to the number 65. The character “B” is mapped to the number 66 and so on. The CHAR() function receives an number as input and returns the character associated with that number. – Syntax:

## Excel Functions and Formulas, INDIRECT()

The INDIRECT() function returns a reference specified by a text string. For example the formula below: =INDIRECT(“A1″) returns the value in cell “A1”. You can download the workbook related to this article here. Jump To: Syntax Example 1, Get Value From List, Based on Row Index Example

## Excel, Date() Function

The Date() function can be used to specify a date value in a cell. Jump To: Syntax Example 1 Example 2 Example 3 Example 4 You can download the file for this article here. – Syntax: =Date(Year, Month, Day) Year: The year value of the date

## Excel Functions and Formulas Sample #1, Split Strings Based on Delimiter

In this article I will provide an example on how you could split a string based on a delimiter character using excel formulas and functions. You can download the workbook for this article here. Jump To: Function Used in this Example Summary Implementation Step 1, Indice Column

## Excel Functions and Formulas, Adding (Concatenating) Text

Adding (Concatenating) text in cells can be done using the “&” symbol. In the example below cell D2 adds (concatenates) the strings in cells A2, B2 and C2: Result: By modifying the values in the cells A2, B2 or C2 the value in D2 is automatically updated: