That's the exact result I get with a single two-column sort, sorting by C2 and C1 in that order.
That's the exact result I get with a single two-column sort, sorting by C2 and C1 in that order.
Entia non sunt multiplicanda sine necessitate
I have to admit, I didn't think of Two-Column Sort. But that isn't working properly either. I'll post why in a moment.
Last edited by Suamere; 08-22-2011 at 01:36 PM.
The reason why is that it is keeping Column B sorted. Column A is not alphabetical for the overall list, it is only alphabetical for each set of like-data in column B. Two-Column sort first sorts the first column, then sorts any grouped values in the second column.
ab - bb
ae - bb
ag - bb
aa - bc
ac - bd
ad -
af -
I need to imitate the possibility of
A. Sort column B (so empty space is on the bottom)
B. Sort column A where there is data in column B (B will become unsorted, but that is okay)
But even when doing that, Column A becomes fully re-sorted instead of just the selected data.
Last edited by Suamere; 08-22-2011 at 01:52 PM.
Select only the rows of cells you wish.
I'm not sure what else to say. I copied your data, sorted as I described, and got your desired results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks