| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting multiple columns alphabetically
I have a huge list in column 1 that I have sorted alphabetically. I have
smaller additional lists in column 2 & 3 (column 2 is a name, column 3 is a number these have to stay together) I would like to sort so that the name in column 2 will go to the row that the name is listed in column 1. (All the names in 2 will be in 1). |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting multiple columns alphabetically
Sort Column A by itself. Then sort columns B & C by column B. HTH Otto
"RB" wrote in message ... I have a huge list in column 1 that I have sorted alphabetically. I have smaller additional lists in column 2 & 3 (column 2 is a name, column 3 is a number these have to stay together) I would like to sort so that the name in column 2 will go to the row that the name is listed in column 1. (All the names in 2 will be in 1). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting columns alphabetically | Excel Worksheet Functions | |||
| sorting multiple columns | Excel Worksheet Functions | |||
| Sorting Alphabetically | Excel Discussion (Misc queries) | |||
| Sorting data in a cell alphabetically | Excel Worksheet Functions | |||
| Sorting multiple columns as 1 list alphabetically? | Excel Discussion (Misc queries) | |||
Hybrid Mode
