Advanced sorting

Hi,

you may have to introduce a few helper columns to enable the sorting.

Excel does not like empty rows in a list. When you use Autofilter (Data - Filter - Autofilter), an empty row will signal the end of the list to Excel.
So, you may want to have a new column, preferably to the very left, where you keep some kind of ID, like a consecutive number or some such thing. This column should be filled in for EVERY row of data, so Excel can tell how many rows of data your list has.

Try to apply the filters and sorting capablilities of Autofilter column by column. If you can't achieve the desired result, go back one step and ask yourself "How is Excel supposed to identify what I want to show". Then look at your data and see if you can figure out some logic. Maybe you need to insert another helper column somewhere to guide Excel to achieve the right sort order.

You could also post a workbook with a subset of your data to illustrate what you want to achieve.

cheers

It would be better practice to replace all the blank entries with replications of the data above, and remove the blank rows. Then you can sort in the normal fashion. You could use conditional formatting to suppress display of those cells.