Tag Archives: Sort

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

How to sort bar chart in descending order?

Posted on July 6, 2019 by MF

Sound like a silly question, but it is a bit confusing indeed. One day, a friend asked me how to sort a bar chart in descending order.  I told her to sort the data. She replied: “I did.  The data … Continue reading →

Rate this:

Posted in Chart | Tagged , | 1 Comment

Sort Warning?!

Posted on May 6, 2017 by MF

Sorting is one of the basic features in Excel.  I believe most Excel users, if not all, know how to sort in Excel.  Without any scientific research, I think most users would click the “Sort A to Z” (ascending order) … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 2 Comments

Copy and Paste can do so much…

Posted on February 18, 2017 by MF

Answer to the 5 little Tips (tests) – Part 5/5 The task: To sort the following dates in descending order.  Sound silly but… The first thing you would probably do is to go to Data tab and then click the Sort Z to A icon? … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 22 Comments

Sort by row (i.e. from left to right)

Posted on January 23, 2016 by MF

Sorting is easy, when the orientation of data is vertical. Although we are expecting data in a vertical layout, it is not uncommon that we still encounter data in a horizontal layout in real world.  Don’t you? With data in a row, … Continue reading →

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | 2 Comments