The Advanced Sort feature is really good, however I ran into the following problem. I want a column sorted by frequency of values in that column and this is one of the features. However it does not give my the option of making all the other columns follow the order of this column! So the data does not match with the other columns. In a regular excel sort, it always asks you if you want to expand the selection, and I need this option in the advanced sort as well!
Any ideas?