> 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" <dnmcnNOS...@comcast.net> wrote in message
> news:uE5iWwZXKHA.1280@TK2MSFTNGP04.phx.gbl...
>> 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
|
