Tag Archives: UNIQUE

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