|
» How Excel Sorts Lists
CATEGORY: Excel Sorting |
VERSIONS: All Microsoft Excel Versions |
|
Excel sorts Lists according to a defined order, as follows: Numeric values Numeric values, including date and time, are sorted from lowest (negative) to highest (positive). Excel does not consider the format of the cell, only its contents. Date and time are sorted by their numeric values. Text Text is sorted first by ASCII characters, such as *, (,), $, and then by letters of the alphabet (also ASCII characters). Uppercase text is sorted before lowercase text. To sort using case sensitivity: From the Data menu, select Sort, then Options, and then select the Case Sensitive option. Logical values FALSE is sorted before TRUE. Errors Errors do not undergo internal sorting, and appear next to last. Empty cells Empty cells are always sorted last. Sort Descending changes the sort order from the last to the first, except for empty cells, which are always last. |
|
RATING:
2.54
VIEWS: 48226 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Windows XP for Dummies
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
