- 2,468,054 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- How to sort bar chart in descending order?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Show number in thousand (k) or in million (M) by using custom format
- When unhide row doesn't work...
- Perform VLOOKUP with 2 lookup values
- Filter a list of items from a long long list
- Open an embedded Excel file during a slide show in PowerPoint?
- Be cautious when using XLOOKUP
- Dropdown calendar in Excel
- Insert a text string into a specific position of another text string in #Excel
My YouTube Channel
- My Tweets
Author Archives: MF
Did you notice that there is a “Reapply” button next to Filter on the Data Tab of ribbon? And wondering what it does? 🤔 Indeed, the “Reapply” button is dim until you have applied filter to at least one column. … Continue reading
In the previous post Rename column names in a dynamic way with #Excel #PowerQuery, I talked about the key steps involved to rename column names in a dynamic approach; and the inspiration as well as the thinking process. As mentioned at … Continue reading
Situation: We have many different tables to be appended. It should be a simple task with Power Query. You may refer to my blogpost here for the basic of appending tables with Power Query. Nevertheless, life could be challenging in … Continue reading
Don’t make me wrong. I am not complaining Power Query at all. If you have followed me for a while, you should know that I am a big fan of Power Query indeed. It is simply powerful! With Power Query, … Continue reading
In the previous blogpost, I showed you how to use INDIRECT to prepare a summary table based on values from different ranges across worksheets. In this post, I am going to show you how to do that with Power Query. … Continue reading
There are many #Excel functions that you may not find them useful when you first learn them. Sometimes you may even doubt why there are such functions. INDIRECT should be one of them. 🤔 What INDIRECT does? It returns the … Continue reading
Applying filter in Excel is a very common task. We used to filter a dataset and focus on a subset of data that we are interested in. It is super easy to filter. The problem is, are you sure you … Continue reading
Are you using Excel 365 but not sure what’s new? Have you heard about all the amazing new functions/features like Dynamic Arrays in Excel 365 but not sure what they are? Or you have no idea at all how Excel … Continue reading
Part 2 – What if we have inconsistent table structures across files? Note: this is a long post. 😉 This is the continuation of previous post. Suggest you read that post first if you are new to Power Query. Moreover … Continue reading
Note: This is a long post… 😉 Part 1 – What Power Query does for us in the process? If you know about Power Query, you should know that combining files in a folder is a powerful yet simple task … Continue reading
Is it possible in #Excel? Of course, as you have just seen it! 😁 Indeed, it’s easier than you may have thought about. We can do it by custom format. First of all, select the cells that you want to … Continue reading
2020 comes to an end in just a few hours . I guess it’s the first time majority of people shares the same new year wish. It was a though year. Keep in faith! Tomorrow will be a better day! … Continue reading
Have you ever had more than 10 workbooks opened at the same time? Did you spend too much time to close them all one by one? If so, you will love this simple trick to close all workbooks simultaneously! The … Continue reading
This post is inspired by the article – Dense Ranking in Power Query, written by PHILIP TREACY from myOnlineTraingHub. The first part of this post is a summary of what I read from Philip’s post. While the second part is … Continue reading
Have you ever encountered a situation like this? How are we supposed to work with a PivotTable without seeing the data fields? I was so lost when I saw this from a workbook on my friend’s notebook. He came to … Continue reading
Situation: In a filtered range of data, we made few changes on the side. Then we want to replace the original values with the updated values. What action appear on top of your mind? Copy and Paste of course. But… … Continue reading
Happy Halloween! 👻 Let’s do something fun. You are invited to leave your comments below. For what? For sharing with us any “weird” formula that you have ever seen in Excel. Real cases please. 😁 Wait… what do I mean … Continue reading
It is a common task that we want to input and maintain all data on one worksheet, and display summary on different worksheets. A typical layout will be similar to the screenshot shown above. One “Input” sheet, and then one … Continue reading
Got this question from my brother. He is tracking scores for game he plays with friends. The game can be played with up to four players. He wants a formula to calculate the last 10 scores of a player. He … Continue reading