Blog Stats
- 2,329,282 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?
- 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
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Filter a list of items from a long long list
- Insert a text string into a specific position of another text string in #Excel
- Open an embedded Excel file during a slide show in PowerPoint?
- Dropdown calendar in Excel
- Be cautious when using XLOOKUP
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Filter
Replace values in filtered ranges using Copy and Paste trick in #Excel
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
Filter a list of items from a long long list
A simple but practical tip of using Advanced Filter I came across a blogpost from Jon of Excel Campus (one of my favorite Excel sites) last week. In his post, he showed how to filter for a list of items using a reverse … 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
Where are Filter drop-down buttons?
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