| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting by first column then by second column
when I use data sort for two columns (Last Name, First Name) why is the
second column not alphabetically correct? John before Betty with both having a last name of Andrews? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting by first column then by second column
BAENOW, when I sorted, it worked correctly. You might check to see if you
have any leading spaces in the names using the Len function. If you do, you can get rid of them with the Trim function. -- Sincerely, Michael Colvin "BAENOW" wrote: when I use data sort for two columns (Last Name, First Name) why is the second column not alphabetically correct? John before Betty with both having a last name of Andrews? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Column sorting | Excel Discussion (Misc queries) | |||
| Sorting Data From One Column into Multiple Columns | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Adding a KeyID column for sorting | New Users to Excel | |||
Linear Mode
