- 2,371,722 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- How to sort bar chart in descending order?
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- Filter a list of items from a long long list
- Be cautious when using XLOOKUP
- Dropdown calendar in Excel
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
My YouTube Channel
- My Tweets
Monthly Archives: May 2015
This is about how to filter a particular date, say 1st of January regardless year, from a list of dates. As a matter of fact, not many people are aware of the Date Filter feature in Excel. This is true at … Continue reading
Have you ever encountered a filtered range without Filter drop-down buttons available on the top? No idea what I am talking about? Take a look at the following screenshot. Without the Filter buttons on the top, I tried to show hidden … Continue reading
In the process of writing my previous post, I found something wrong with Filter… when Column A contains formula starts with SUBTOTAL, Auto Filter refuses to take the last row.
How to display a column of sequential number to visible rows only? Got this question from a friend. Her task is simple as shown below: I guess many people wanted to achieve the same thing but have no idea at all. Are … Continue reading