Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I created an excel spreadsheet for database information.
I have 7 columns The first 4 columns are in order by last name, with matching title, and organization, as they should be. However, in doing some sorting of zip codes, I now have the last 3 columns which include the addresses city, state and zip code in their proper order (matching) however, they now do not match with the first 3 columns. How can I put them back in the right order to match? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can't.
Go back to your original data and sort again, but next time ensure that you select the full range (columns and rows) before you ask Excel to sort. It is unwise to allow Excel to guess what you want sorting, as you have discovered. -- David Biddulph "Quiche" wrote in message ... I created an excel spreadsheet for database information. I have 7 columns The first 4 columns are in order by last name, with matching title, and organization, as they should be. However, in doing some sorting of zip codes, I now have the last 3 columns which include the addresses city, state and zip code in their proper order (matching) however, they now do not match with the first 3 columns. How can I put them back in the right order to match? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting | Excel Worksheet Functions | |||
SORTING | Excel Discussion (Misc queries) | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Sorting | New Users to Excel |