Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a spreadsheet with multiple columns and over 4000 rows. I need to sort, then alphabetize my report and everytime I do, there are 43 rows that do not sort with the rest of the report; they go to the top or bottom of the report and are alphabetized as a separate group. I've tried deleting them and re-entering them and trying all over to get them to alphabetize with the rest of the report but they continue to stay separate. Why is this happening? Any help will be appreciated.

share|improve this question
2  
We'd need to see the data to give a full answer. –  Lee Taylor Nov 28 '12 at 20:10
2  
Can we get some screenshot for that column which doesn't sort? –  Mowgli Jun 20 '13 at 14:57
add comment

3 Answers

Sounds like those 43 rows each has a column with a leading blank. Blanks precede printable characters in common sorting algorithms. That would account for the behavior you describe.

share|improve this answer
add comment

If you've reentered the data it is likely you've gotten rid of blanks. It is possible the rows are not included in the sort because they are not selected. If those 43 rows are not included in the sort grouping, they will not be sorted in the order you choose and will appear in their own group. Verify they are being included and retry the sort.

Also, make sure you don't have another conflicting sort or filter which is causing your issue.

You've not told us what type of data you are using. Mixed data can cause all kinds of issues with sorting. If it is mixed, it should be formatted as text. Here is more info about how to troubleshoot sorting.

share|improve this answer
add comment

This can also happen if you create a filter, then add new data. Try removing the filter and sorting again.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.