[Affiliate]
Blog Stats
- 3,289,904 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- #Excel Add current selection to filter. What it does?
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Show number in thousand (k) or in million (M) by using custom format
- Dropdown calendar in Excel
- Contact
- Limitation (or bug?) with Filter by Color
- About
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- A trick to SUM visible columns only (without VBA)
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
What I did during the CNY holiday? To build my 1st dashboard…
During the past CNY holiday, I read a book called <Information Dashboard Design – Display data for at-a-glance monitoring> by Stephen Few. Special thanks to my friend who borrows the book for me! Well, this is not an Excel book. … Continue reading
Why do you turn off Auto Filter and then turn it on again??
I have seen many people turning OFF and then ON Auto Filter in order just to SHOW ALL values (in Excel 2003’s terms) or CLEAR all filters (in Excel 2007 or above’s terms). Frankly, I think many people do this … Continue reading
Time Conversion – How to convert 24hr input as 4-digit number into TIME in Excel?
How to convert something like 1200 into 12:00? For easy sake of input, we often input 24-hr time as four digit number like 930 for 9:30, 1815 for 18:15 etc. However, if time is input in this way in Excel, … Continue reading
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
Alternative to vlookup – Index and Match
Lookup from Right to Left In the above example, if it is given the Student ID, it would be so easy to find one’s corresponding Name and Grade by using vlookup. However, if we would need to find out the … Continue reading
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
How much do I need to pay?
This is not an Excel question… Just had a happy dinner gathering with friends! Good food, good friend, and good price… 🙂 While a friend was calculating how much to share by each of us, others asked me how to … Continue reading
Posted in General
Leave a comment
Advanced vlookup – Text vs. Number
Why does vlookup not return the lookup value? I am sure it is in the source data table. I see it by my eyes. Have you ever experienced this?? That’s normal when you import your data from other database. Fortunately … Continue reading
vlookup – True or False??
Usually we use vlookup for answering a particular question like “How many customers we had on January 1st 2014?” We expect an exact match and hence using FALSE as the last argument in the vlookup formula. When do we use … Continue reading
vlookup with Match
Hard-coding the col_index_num in the vlookup formula is not a wise choice as you might have to look into the formula and make changes every time you copy and paste your formula. An alternative approach of marking column index on … Continue reading
Tips in constructing vlookup
Tips in constructing vlookup We talked about the syntax of vlookup and we had written a vlookup formula successfully in the previous post. YEAH! Now we want to ride on the formula by copying it DOWN and to the RIGHT … Continue reading
The basic of vlookup
vlookup – Something you should know about The basic of vlookup Definition of LOOKUP (http://www.merriam-webster.com/dictionary/lookup) : the process or an instance of looking something up;especially: the process of matching by computer the words of a text with material stored in memory v, in the … Continue reading
Use Format Painter to decorate your spreadsheet
Christmas is all around. Perhaps you are busy with decorating your Christmas tree with lots of joy. However it’s no joy to decorate your Excel worksheets in your daily work. It could be really time-consuming to apply the same set … Continue reading
Where did I save this file???
One day, a colleague suddenly asked me: “do you know where I saved this file?” by showing me her monitor with the file opened… Well, the first thing came to my mind was…… well……, input this formula in any blank … Continue reading
Excel Basic – Looks can be deceiving
Once upon a time, I was questioned about the accuracy of calculation in Excel just because one saw a formula “3% x 100” (A1*B1) yielding a result of 2.5 (C1). WHY???? As a basic but important rule, DO NOT trust … Continue reading
Where is the formula referring to???
This is an extension of my post – Teleport in Excel I don’t remember how many times I want to know where a formula is actually referring to, esp. when I need to spot what’s the formula doing. If the … Continue reading
Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques. I had encountered a file with thousands of records (rows) that keeps track of details of different jobs. Finished jobs were identified by Strikethrough … Continue reading
Calculating % Change is so easy… to make a mistake!
How to calculate percentage change with negative number? I believe calculating percentage change should have a very top ranking on the most frequently used calculations in spreadsheet. Agree? For me, I often simply do the calculation with a simple formula: … Continue reading
wmfexcel 
How to insert picture / photo into comment?
Happy Valentine’s Day!! Tomorrow is a very special Valentine’s Day as both Chinese and Western Valentine’s Day fall onto the same day. It happens only once in every 19 years. Let’s send your special feeling to a special person subtly … Continue reading →
Rate this: