| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort 2 columns similtaneoously
I have two columns that I would like to keep together.
Street and house number. Is there someway to make the street the primary sort and carry the house number (which is in a separate column) along with it? In other words, I'd like for the street name to be in order and the house numbers to be in sequence for that street. Thanks, Doug |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort 2 columns similtaneoously
Select the data (it works best if the columns have labels in the top cells)
Use Data Sort Specify sort first by Street then by Number If there is more info (such as names) , make sure you select tall relevant columns before sorting Play save: do a Save As and work on this copy of your data until you know you have it right best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Doug Mc" wrote in message ... I have two columns that I would like to keep together. Street and house number. Is there someway to make the street the primary sort and carry the house number (which is in a separate column) along with it? In other words, I'd like for the street name to be in order and the house numbers to be in sequence for that street. Thanks, Doug |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sort 2 columns similtaneoously
Thanks Bernard,
How do I tell Excell that the top 4 rows are titles and how do I tell it to print them on each page? "Bernard Liengme" wrote in message ... Select the data (it works best if the columns have labels in the top cells) Use Data Sort Specify sort first by Street then by Number If there is more info (such as names) , make sure you select tall relevant columns before sorting Play save: do a Save As and work on this copy of your data until you know you have it right best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Doug Mc" wrote in message ... I have two columns that I would like to keep together. Street and house number. Is there someway to make the street the primary sort and carry the house number (which is in a separate column) along with it? In other words, I'd like for the street name to be in order and the house numbers to be in sequence for that street. Thanks, Doug |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort by color: Is there an easy way to sort columns or rows in EX | Excel Worksheet Functions | |||
| sort by two columns ends up with wrong sort in 2nd col | Excel Discussion (Misc queries) | |||
| Sort command does not sort some columns? | New Users to Excel | |||
| How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
Linear Mode
