Jul 8 2009

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

Mar 23 2009

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

Jan 24 2009

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.

TAGS:
Dec 29 2008

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

Dec 8 2008

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

Page 1 of 512345»
  • Get Expert Excel Help Today! 714.262.6893

Categories

Excel Poll of the Week

How often do you use Excel at work?

View Results

Loading ... Loading ...