LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 5
Default excel 2011 won't sort alphabetically

Hi,
I'm trying to sort a spreadsheet of fern information alphabetically, first by column A (genus) and then by column B (species). Columns C-F contain additional information.

I've selected data sorting in the order of Column A then Column B.

However, it consistently puts some items out of order for column B, making it difficult for me to check the species information. I've double checked for extra spaces, there are no extra characters. I don't understand what's happening.

Example:
Sorted alphabetically, Dryopteris marginalis will be listed before Dryopteris goldiana.

Or it will list
Dryopteris marginalis
Dryopteris marginalis
Dryopteris intermedia
Dryopteris marginalis
Dryopteris marginalis.

Can anyone help? Thank you!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I sort alphabetically in Excel seh60025 Excel Discussion (Misc queries) 1 October 26th 06 10:25 PM
How do I sort contents alphabetically in Excel? Lila Bean Excel Discussion (Misc queries) 1 May 4th 06 05:41 PM
How do I sort my excel list alphabetically by last name? JIMC Excel Discussion (Misc queries) 2 February 21st 06 10:40 PM
How do I sort in Excel alphabetically? Jennifer Excel Discussion (Misc queries) 2 January 20th 06 04:42 PM
How do I sort alphabetically by last letter in Excel? andrewcodd Excel Discussion (Misc queries) 3 July 27th 05 04:09 PM


All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"