Tag Archives: Filter

Simple Basket Analysis – Formula approach with #Excel 365

Posted on March 25, 2023 by MF

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 →

Rate this:

Posted in Excel 365, Excel in Action, Formula | Tagged , , , | Leave a comment

[Video] How to create a dependent dropdown list in #Excel

Posted on July 1, 2021 by MF

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 →

Rate this:

Posted in Excel in Action | Tagged , , , , , | Leave a comment

The very hidden gem of AutoFilter in #Excel

Posted on May 30, 2021 by MF

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 →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

The proper way to filter values not equal to zero in #Excel

Posted on May 22, 2021 by MF

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 →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Reapply Filter in #Excel

Posted on May 15, 2021 by 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 →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Filter: It’s easy and not easy

Posted on March 7, 2021 by MF

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 →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Replace values in filtered ranges using Copy and Paste trick in #Excel

Posted on November 14, 2020 by MF

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 →

Rate this:

Posted in Excel Tips | Tagged , , | 2 Comments

Filter a list of items from a long long list

Posted on August 2, 2017 by MF

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 →

Rate this:

Posted in Excel Tips | Tagged , , | 7 Comments

Limitation (or bug?) with Filter by Color

Posted on January 30, 2016 by MF

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 →

Rate this:

Posted in Excel Tips | Tagged , | 16 Comments

Where are Filter drop-down buttons?

Posted on May 23, 2015 by MF

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 →

Rate this:

Posted in Excel Tips | Tagged | 32 Comments