0
Undo
Votes
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?
Any ideas?
0
Undo
Votes
Yeah I got the answer myself!
Before you do the advanced search, don't select that column that you want sorted, rather select the whole sheet, and in the advanced sort THERE you select which column you want sorted and all the other columns will also be sorted!
Before you do the advanced search, don't select that column that you want sorted, rather select the whole sheet, and in the advanced sort THERE you select which column you want sorted and all the other columns will also be sorted!
- Page :
- 1
There are no replies made for this post yet.