Monthly Archives: May 2014

OMG – I forgot SAVE…

“I started a new workbook.  Worked so hard to create a report from scratch.  Meanwhile I opened many other workbooks to get the data I needed.  Then I realized that too many workbooks were opened.  I closed some of them … Continue reading

Rate this:

Posted in Excel Basic | Tagged | Leave a comment

First thing to do when switching from Excel 2003 to 2007/2010

is to know where are the old menus and toolbar icons!!! I guess there are still a lot of of Excel 2003 users in Hong Kong, mainly in workplaces.  No idea if it is also common in other cities. There are … Continue reading

Rate this:

Posted in Excel Basic | Tagged , | Leave a comment

Perform VLOOKUP with 2 lookup values

4 different ways to perform LOOKUP with 2 lookup values We know that VLOOKUP is very useful. At the same time, we know that VLOOKUP has its limitations. E.g. VLOOKUP only looks from left to right; VLOOKUP only handle one … Continue reading

Rate this:

Posted in Formula | Tagged , , , , | 35 Comments

Format part of a formula result… A workaround (non-VBA) solution

How to format part of a formula result? In a normal text string, we may format part of the text to highlight a specific information.  For example, if we input the text string “Today is Thursday, 01/05/2014” in A1, we … Continue reading

Rate this:

Posted in Excel Tips, Format | Tagged , | 6 Comments