Pecoflyer calculated year number for Helper column. I changed his/her file so a date is calculated instead. And you never must sort by Date column - only by Name or Helper columns!
Now some rules:
To sort the table by single column, activate a single cell in this column, and then either click on filter box of same column, and select Sort Oldest to Newest/Newest to Oldest, or activate Sort Filter from Home menu and then select Sort A to Z/Z to A or selct Custom Sort, and define sorting rules there (the last option works with any single cell in table activated);
To sort the table by several columns at once, activate any single cell in table, and then use Custom Sort and add as many rules as you need.
NB! When activating sorting, you must have a single cell in table activated! Whenever a block of sell is activated, the sorting applies only to this block! I.e. when you have a column of data selected, and sort this column, only data in this column will be sorted - all other columns remain in old order, and your table is in bucket!
|