[Affiliate]
Blog Stats
- 3,070,578 hits
-
Join 3,281 other subscribers
- 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?
- Show number in thousand (k) or in million (M) by using custom format
- How to replace value with a value from another column in Power Query
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Insert a text string into a specific position of another text string in #Excel
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Open an embedded Excel file during a slide show in PowerPoint?
- Send a cell content to Google search
- How to put the Date Modified info on #Excel worksheet using #PowerQuery
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Filter
Simple Basket Analysis – Formula approach with #Excel 365
The challenge – How many transactions with just Brand A and B together? In my previous post / video, I solved this problem with Power Query. If you are using #Excel 365, did you know you can solve this problem … Continue reading
Posted in Excel 365, Excel in Action, Formula
Tagged ARRAYTOTEXT, Filter, Sort, UNIQUE
Leave a comment
[Video] How to create a dependent dropdown list in #Excel
This is the follow up post from my previous post – How to create a dependent dropdown list in #Excel. As mentioned, it could be easier to illustrate the concept using a video, especially for the use of Dynamic Arrays. Here … Continue reading
Posted in Excel in Action
Tagged Dependent Dropdown, Dynamic Arrays, Excel Table, Filter, INDIRECT, UNIQUE
Leave a comment
The very hidden gem of AutoFilter in #Excel
Don’t get me wrong. I am not talking about the Filter button sitting on the Data Tab of ribbon, although they look almost exactly the same. I am pretty sure that most people who use Excel five days a week … Continue reading
The proper way to filter values not equal to zero in #Excel
I didn’t think of blogging about this topic before. I thought that it is so straight-forward. Nevertheless, there is another way of doing so which is even more straight-forward BUT may give you unexpected results later on. And to my … Continue reading
Reapply Filter in #Excel
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
Filter: It’s easy and not easy
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
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