I think I've done as you said, but get "merged cells must be indetically sized." Any ideas?
It may be a different version. Autofilter for data is what you need for the ascending sort. If the autofilter has a merged cell in there it will not sort. So, off the top of my head as I do not have excel at home.
Highlight the whole table from the line with OOM, troop type, etc, down
to the bottom of where you can place troop descriptions and include the cells with calculations to the right.
The pink line on here where it says error is the top line to select then down to the last line of troops and all the way to the right.. (Sorry Olivier I opened it in OO and played with the locked sheets)
Then ensure none of these cells are merged. To do this right click, format cells, alignment tab, unclick the merge cells tick box, this will be filled if any cells are merged, ticked if all cells are merged, you need it empty. Then from the menu bar, data, filter, autofilter. This will then hopefully put the drop down arrows in the line at the top of the cells you have selected.
Although none of this matters with the new version on the link above as it has autofilter already. Which is easier than this.