Posted on February 19th, 2009 by Joseph Harris
Today I came across a problem I see at least once or twice a week. I wanted to perform some analysis using an employee number. The output from one of my systems included the employee number with GLK_RDT at the beginning of the number. Since I needed the numbers alone, I needed to remove the annoying 7 [...]
Read More
Posted on February 18th, 2009 by Joseph Harris
Surfing the web today, I came across a great user defined function (UDF) called sumcolor(). This function sums a range of cells based on the color of the cells. My head began to spin with the possibilities! Below is the VBA for the function. If you are unfamiliar with how to install a UDF, here is [...]
Read More
Posted on February 16th, 2009 by Joseph Harris
Reader Writes: Joseph, I have a spreadsheet set up where I enter all of my companies “packages shipped” data. I would like to know the value of the last row that I inputted. So, if column A contains packages shipped on each row, I want to know the last number entered in column A. Thanks, Carl [...]
Read More
Posted on February 9th, 2009 by Joseph Harris
Excel Solver is back in Excel 2008…
Read More
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 [...]
Read More
Posted on December 9th, 2008 by Joseph Harris
Today a colleague told me they were going crazy because they kept accidentally clicking on emails in an email list they maintained in Excel. I said, why don’t you turn off the hyperlinks then you will not have to worry about it. My colleagues face went blank….”You can do that?”. Steps to disable auto hyperlinks [...]
Read More