Archive for January, 2010
Nifty Tip #2: Combining the VLOOKUP and MATCH formulas
The VLOOKUP formula returns data from any column you choose in the data table. All you have to do is change the number of the column in the third argument, right? Well, it sounds easy, but there is a little catch. How can you determine the number of a column in a data table that [...]
Figart Consulting’s Excel Nifty Tip #1.5
NIFTY TIP # 1.5: Splitting a Full Name into Two Separate Cells Problem: You have inherited a mailing list with hundreds of names. You’ll need to be able to sort the list alphabetically and you notice that the individuals’ first and last names are together in the same cell. Your blood pressure rises as [...]
Figart Consulting’s Excel Nifty Tip #1
Figart Consulting will be offering a free series of Nifty Tips to help you solve common office problems without strangling your co-workers, clients or supervisors. Since so many of these issues involve Excel, the series will start there. If a solution is specific to a software version, we will make sure to make that clear [...]