Posted on February 9th, 2009 by Joseph Harris
The standard vlookup function allows for one condition to be looked up. For example, if I have the data in rows 1 through 7 below, and I want to determine the favorite color of Dan, who was born in Jan and is 16 years old, the standard vlookup function will not work.
The standard vlookup function [...]
Posted on February 3rd, 2009 by Joseph Harris
Microsoft Excel has a limit of 3 criteria in Conditional Formatting. We can get around this with a bit of VBA code…
Private Sub Worksheet_Change(ByVal Target As Range)
Dim intclr As Integer
If Not Intersect(Target, Range(”A1:z100″)) Is Nothing Then
Select Case Target
[...]
Posted on February 3rd, 2009 by Joseph Harris
A chart that can be used to look up the colorindex integer to see the corresponding index color [...]
Posted on January 5th, 2009 by Joseph Harris
Quick an easy method of making your Excel graphs more appealing, by adding pictures.
Posted on December 12th, 2008 by Joseph Harris
Simple multiple user password protection in Excel.
Posted on December 2nd, 2008 by Joseph Harris
There are many occasions when you may need to remove rows that contain duplicate information. There are two quick and easy methods to accomplish this.
Methods for Removing Duplicates:
Autofilter
The & operator
To use method 1:
Select the list of data where you would like to delete duplicate rows (including headers). In the data menu select “advanced filter”, choose [...]
