[Affiliate]
Blog Stats
- 3,289,850 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- #Excel Add current selection to filter. What it does?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Limitation (or bug?) with Filter by Color
- Show number in thousand (k) or in million (M) by using custom format
- How to sort bar chart in descending order?
- Dropdown calendar in Excel
- Combine files in a folder with Power Query in #Excel
- Do you know Menu Key??
- The INDIRECT trick of using Structured Reference in Conditional Formatting
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
Lost in colors
Which one of the following charts use better colors? It is not surprising if you prefer the one on the left as the colors used are of high contrast. However, will you change your mind after you read the same … Continue reading
Posted in Excel Tips, General
Leave a comment
Input fraction number in Excel
This title sounds a bit silly, but I do believe many users must have experienced frustration when they tried to input a fraction number as simple as 1/2 in Excel. When we input something like x/y, Excel assumes that we are … Continue reading
Rank in subgroup… RANKIF?
To get the overall ranking is easy with the RANK function. The syntax of RANK =RANK(Number,Ref,[order]) Number is the number we want to rank; Ref is the list of numbers of comparison (could be an array, a reference or a list … Continue reading
Don’t Miss Out on the Early Bird Registration for Allen Wyatt’s Excel Macros for Beginners course
About a week ago I let you know about Allen Wyatt’s Excel Macros for Beginners course. At the time, I invited you to visit Allen’s overview for the course, and I told you that you could register for this excellent … Continue reading
An example of using Solver for a causal problem in daily life
This post is intended to give you an example of using Solver in Excel to solve a causal problem in daily life – buying postal stamps. Don’t consider it a tutorial. 😛 Have you ever heard of Solver in Excel? I think … Continue reading
Want to learn Macro? Here’s the chance.
If you have been following my blog, you should know that I focus on tricks and tips of “preset” ways in Excel. For some people, using those preset ways is enough, but for others, Excel may be a bit restrictive … Continue reading
Convert .xls to .xlsx in a few clicks
Let’s bring the Excel file from stone age back to modern world. A few years ago, my company switched from Office 2003 to Office 2007. I was one of the very few who felt excited about the change. On the … Continue reading
Posted in Excel Basic, Excel Tips
Leave a comment
Make impossible possible
Convert text of specific pattern like “1d 2h 3m 4s” into real time (26:03:04) in Excel To kick start the Year of Monkey, let’s challenge the apparently impossible… Do you think it is not possible in Excel? If you do, you … Continue reading
Calculate number of “*day” in a given period
This post is about how to twist the NETWORKDAYS.INTL function to solve the question. About two years ago, I wrote a post <Calculate number of a specific day between two dates> to explain how the following formula (Solution 1) could solve the question: … Continue reading
Limitation (or bug?) with Filter by Color
Did you know that you can filter by color since Excel 2007? Yes, that’s almost 10 years. I wont’ say it is a new feature notwithstanding the fact that many people are not aware of it yet. 😛 Filter by … Continue reading
Sort by row (i.e. from left to right)
Sorting is easy, when the orientation of data is vertical. Although we are expecting data in a vertical layout, it is not uncommon that we still encounter data in a horizontal layout in real world. Don’t you? With data in a row, … Continue reading
Display % of column and % of row in a dynamic way
This post is intended to give you an introduction of CHOOSE function and Option Button (Form Control). Here’s the situation: We want to display the % of total in a 2-D table. Nevertheless the % can be of column total … Continue reading
Excel Humor #3 – Advanced User
Happy New Year!!! Wish you a happy, healthy and prosperous year of 2016. In a word, wish you EXCEL in 2016! 🙂 Let’s start the year with FUN!
VLOOKUP the Nth matched item, with helper column
This should be the last post in 2015. So it’s better to answer unanswered question in the year. 🙂 Question: “VLOOKUP will return the first matched value found, in case there are multiple matched records what formula should we use?” This … Continue reading
How to limit time interval input in a single cell?
Got the following question from a reader: Under data validation, is it possible for me to restrict the time duration (in a cell) to be 30mins or less? Example: 9.00 – 9.30 (accepted) 10.15 – 10.50 (rejected) Obviously, the answer … Continue reading
A simple trick to go to a specific picture quickly
Here’s the situation: You have many pictures on a spreadsheet, how can you go to a specific picture quickly? Selection and Visibility Pane is on the top of my mind…… but as you see from the above screenshot, you won’t succeed … Continue reading
Excel Humor #1 – Home
I am now having fun somewhere in Tasmania; enjoying my vacation 🙂 So let’s have fun this week and the next.
Bug with copy and paste in Excel Table
Do check what you do! On top of human errors, there may be bug hidden. Continue reading
Nested IF vs. VLOOKUP – Which one to use?
A well-drawn flowchart or a well-organized table helps you write a successful formula effectively Continue reading
wmfexcel 