Posted on March 16th, 2009 by Joseph Harris
The question we are asked most often by ExcelYogi readers is how can I use vlookup with multiple criteria or conditions. There are several solutions but some can be pain staking and unrealistic. Knowing that the Excel world is missing this feature, Excel Yogi has created a VLookup addin that will extend the built in [...]
Posted on March 3rd, 2009 by Joseph Harris
It is often necessary to replace characters within a string in Excel with other characters. Or you may want to remove some characters entirely. There are several ways to do this but by far the easiest method is to use the built-in replace tool.
For example, you have the following in a cell:
610-555-2904
You want to remove the hyphens [...]
Posted on March 2nd, 2009 by Joseph Harris
Typically when you use autofilter, the task bar at the bottom of your Excel workbook will say: “5 of 10 records found”. The five is your visible rows. In some situations the records found indicator will not be displayed on the indicator. This can happen when there are many complex formulas in your filtered results. [...]
Posted on February 23rd, 2009 by Joseph Harris
For quick and easy up and down trend arrows in your dashboards and scorecards there is a simple solution…Marlett. If you do not know about this trick, you are probably unfamiliar with the Marlett font in Excel. Marlett was created by Microsoft for Windows and is used as the user interface font in many Microsoft applications. [...]
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 [...]
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 [...]
