Add Hierarchy to Excel’s SORT Function
The SORT function allows you to specify which column to sort by. You can also include a hierarchy to sort by more than one column.
(more…)Excel VBA Sort Sheet Tabs by Colour
Using colours on your sheets can help you navigate and organise your file. If you want to sort your sheets by colour you can use a macro to speed up the process.
(more…)Sort by value and ignore sign revisited
I covered a solution to sorting and ignoring the sign a couple of years back, but it is time to revisit this thanks to dynamic arrays.
(more…)Excel Sort within a Sort
Did you know you can sort by colour in Excel? Did you know you can sort ascending or descending within that colour? I was asked a question in a recent webinar and in answering I found out that you can sort within a sort. (more…)
Inserting a Blank Row Between Entries
Over the years I have had many requests to help people insert blank rows between entries is a list. Apparently it is for an input routine that requires blanks. My normal solution is a macro because it automates the process, but there is a manual technique that is quick and easy. (more…)
Excel Subtotal Sort Magic
Sometimes Excel surprises me. In this case it sorts in a way I didn’t expect, but in a good way. Thanks to Mr Excel for the tip. (more…)
Sorting By Colour in Excel
Yes, you can sort by colour in Excel! This feature makes it easy for you to colour code cells and then place them together at the top of your data set. (more…)
Excel and Side Ways Sorting
I found out something new from one of my webinar attendees recently. You can sort sideways in Excel. (more…)