Check if a Cell Contains Text
Excel provides an easy method to determine if a particular cell contains text. Using the IsText function will return True or False after checking the given cell. Let’s take a look at at how to use this function.
IsText Example
For this example, let’s imagine Cell A1 has the text “Red”, and Cell B1 contains [...]
Functions or PivotTable?
Microsoft’s Excel Blog has an interesting post breaking down the advantages of using either functions or pivotTables to do your analysis. There present the differences with a small example. Check out the comparison here: Analyzing Data: Functions or PivotTables
Separate Full Name into First & Last Name
Here are two easy formulas that will separate a cell that contains a full name (first and last name format) into 2 cells – one containing the first name and the other containing the last name. To do this we are going to make use of the left, right, len & find formulas.
Sum Values in a Range While Ignoring #N/A
Excel provides an easy way to sum a range of cells based on a given criteria. There are many ways this can be used but the example we are going to look at today is summing a range while ignoring #N/A’s in the same range. Without ignoring #N/A, the result of the sum will be [...]
Summing Across Multiple Sheets
You might have come across an instance where you want to use a function against multiple sheets in a workbook. Excel provides an easy way to calculate aggregate functions across a range of sheets. In the examples below, you will see how this can be performed against any range of sheets and sheet names (or even [...]
Loading ...