Blog Stats
- 2,374,298 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Open an embedded Excel file during a slide show in PowerPoint?
- Filter a list of items from a long long list
- Be cautious when using XLOOKUP
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Auto Filter
#Excel Add current selection to filter. What it does?
Get multiple filter criteria with Excel Auto-Filter This post is in response to the following Mr.Excel video where Mr. Excel Bill Jelen solved the problem with Advanced Filter. Indeed I got a similar question from a colleague recently for filtering … Continue reading
Hidden Rows vs. Filtered Rows
One day, a friend asked me: “If she deletes contents from a filtered range, would she also delete the hidden content?” I answered: “Try and observe!” 😛 I know that is not the answer she expected. Nevertheless, I believe that … Continue reading
Date Filter is good, but still with limitation
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
Interesting bug – Filter with SUBTOTAL
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.
Sequential number for visible rows only
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
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