The best solution is to convert the data to use only one unit per column, which may mean adding a new column. The quick-sort method described above is convenient; however, it doesn't work as ...

Using this dialog, you can sort by multiple columns ... or add it to a custom group or even the Quick Access Toolbar (QAT). I’ll show you the macro and you can decide how to run it.

It then proceeds to the right side and performs the same operation again. See sort algorithm. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction requires permission.

JD Sartain / IDG Worldwide Cyan cells sorted to the top alphabetized by AUTHOR’s name For more samples and detailed instructions regarding sorting by colors, values, and icons, and using ...