Tag Archives: UNIQUE

Dependent Dropdown menu using OFFSET in #Excel

Posted on December 16, 2023 by MF

Quite a long time ago, I wrote about two different approaches of preparing dependent dropdown menu in Excel. The first approach was for non Excel365 users, while the second approach was for Excel365 users. You may refer to the post … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , , | Leave a comment

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

Distinct count using functions in #Excel 365 is so easy

Posted on February 19, 2023 by MF

Have your ever wanted to count how many distinct items in a range? Though a common task, there was not build-in functional for it. Perhaps we can make a distinct list using advanced filter first then we count the outcome. … Continue reading →

Rate this:

Posted in Excel 365, Excel Tips, 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