Tag Archives: wildcard

Filter a list of items from a long long list

A simple but practical tip of using Advanced Filter I came across a blogpost from Jon of Excel Campus (one of my favorite Excel sites) last week.  In his post, he showed how to filter for a list of items using a reverse … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 5 Comments

SUM Time in the end of text strings

Did you encounter a task like this?  I did.  Actually it is not as difficult as you may expect.  It could be done in just a minute IF the data is not too bad, like the one shown above. I … Continue reading

Rate this:

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

=SUM(‘???’!C3) Is it a valid formula?? No. It is magical indeed!

This is about using wildcards in referencing cells on other worksheets. If you know the basic rule about naming a worksheet, you should know that we cannot use ? or * in any part of a worksheet’s name.  So there … Continue reading

Rate this:

Posted in Excel Tips, Formula | Tagged , , | 31 Comments

How to lookup only partially-matched value?? – Crazy lookup!!!

This is a real workplace problem. Look at the two tables below, the task was to map the Shop ID from Table 1 (left) to Table 2 (right).  In both tables there is a common key “Shop Name”.  Sound easy? … Continue reading

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | Leave a comment

Advanced vlookup – wildcard characters “?” and “*”

Why vlookup gives me wrong answer??? Bugs in vlookup???  I am sure it’s not about text vs. number, but it still fails to give the correct answer!!! I guess many users are not aware of the wildcard characters in Excel.  … Continue reading

Rate this:

Posted in Formula | Tagged , , | 27 Comments