Tag Archives: wildcard

SUM Time in the end of text strings

Posted on July 25, 2015 by MF

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 Array formula, Find and Replace, RIGHT, Sample File, SUBSTITUTE, SUMPRODUCT, Time, wildcard | 6 Comments

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

Posted on July 11, 2015 by MF

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 3D SUM, Sample File, wildcard | 31 Comments

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

Posted on January 23, 2014 by MF

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 INDEX, lookup, MATCH, wildcard | Leave a comment

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

Posted on January 12, 2014 by MF

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 →