Posted on June 5th, 2010 by Joseph Harris
Subsidium Business Analytics has released its Excel to PowerPoint converter. We though we would take it for a spin to see how it works and if it is worth the money.
Purchase and Install
The Excel to PowerPoint converter cost $4.99 so my expectation was low. I purchased the add-in and an automatic download began. The install [...]
Posted on April 1st, 2009 by Joseph Harris
Many applications that export to Excel, export the data with the apostrophe character at the front of the string. One way of removing this character is to use the clean() function:
If in cell A1 you have: ‘output
Then in cell B1 type =clean(A1). The result will be: output
Joseph Harris
Excel Help
Bookmark It
Posted on March 23rd, 2009 by Joseph Harris
Use the Large and Small functions is Excel to find the Nth largest number in a list.
For example:
=Large(A2:E2,3) will return the 3rd largest value in the data set.
=Small(A2:E2, 2) will return the 2nd smallest value in the data set.
Joseph Harris
Excel Help
Bookmark It
Posted on March 23rd, 2009 by Joseph Harris
There are many ways to remove duplicate rows in Excel, in this articles I will give you a quick and simple method of deleting duplicates using the Advanced Filter.
Assume you have data that contains multiple duplicate rows…
Select all the data that you would like to test for duplicates
Go to Data=>Filter=>Advanced Filter
Select the “unique records only” [...]
Posted on March 18th, 2009 by Joseph Harris
The title of this post is slightly misleading. We will not be using vlookup to return the corresponding result of the last condition, but rather we will be mimicking vlookup to pull the last item.
Consider the following data:
George
Smith
Tom
Thompson
George
Kenny
Dan
Jackson
Sally
Richards
George
Daniels
A vlookup of the name George will return Smith, What if you want to lookup the last George listed? The [...]
Posted on March 17th, 2009 by Joseph Harris
The #DIV/0! error happens when the denominator (the number on the bottom) of an equation is zero. Many times you will want to display a 0 or NULL rather than the #DIV/0! error. Below is a simple way to accomplish this.
Rather than entering =A1/B1, use =if(B1=0,0,A1/B1), if you want a NULL to appear rather than [...]
