A1 = Street number like 1234
B1 = Street name like lake wood drive

I want all records to be sorted by street name (B1) and then the records
with identical street names, to be sorted by their numbers, A1.

Thanks!
Curtis

Curtis Stevens wrote:
A1 = Street number like 1234
B1 = Street name like lake wood drive

I want all records to be sorted by street name (B1) and then the records
with identical street names, to be sorted by their numbers, A1.

Thanks!
Hi Curtis,

Sorting is straightforward, but only if your data is "well-structured".

The most important things for "well-structured" data are

a) Your columns have labels in the first row (e.g., "street number" and
"street name" in row 1)

b) Your rows do not have breaks. I.e., *no blank rows anywhere between
data rows*.

c) Your columns do not have breaks. As in b), do not allow blank columns
to separate your data.

Points b) and c) are particularly important, for different reasons.

Anyway, if you have data that is "well-structured" according to my
definitions, all you need to do is

Put cursor anywhere in the data
Pick Data | Sort
In the Sort dialog,
choose "Street Name" as the first sort
choose "Street Number" as the second sort
click OK

Let's see how that works... Hope you do not have a mix of numeric and
alphanumeric data in "Street number".

Just to add to smartin's post, you *can* sort with blank Rows or Columns
*provided* you select the area to be sorted first. Blank rows will be
sorted to the bottom of the list. It is also good to ensure that "My list
has Headers" is selected if you have headers.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"smartin" wrote in message
...
Curtis Stevens wrote:
A1 = Street number like 1234
B1 = Street name like lake wood drive

I want all records to be sorted by street name (B1) and then the records
with identical street names, to be sorted by their numbers, A1.

Thanks!
Hi Curtis,

Sorting is straightforward, but only if your data is "well-structured".

The most important things for "well-structured" data are

a) Your columns have labels in the first row (e.g., "street number" and
"street name" in row 1)

b) Your rows do not have breaks. I.e., *no blank rows anywhere between
data rows*.

c) Your columns do not have breaks. As in b), do not allow blank columns
to separate your data.

Points b) and c) are particularly important, for different reasons.

Anyway, if you have data that is "well-structured" according to my
definitions, all you need to do is

Put cursor anywhere in the data
Pick Data | Sort
In the Sort dialog,
choose "Street Name" as the first sort
choose "Street Number" as the second sort
click OK

Let's see how that works... Hope you do not have a mix of numeric and
alphanumeric data in "Street number".

Select the whole range of data, (columns A and B, and as many rows as
applicable).

Data/ Sort/ Sort by (Column B) then by (Column A).
--
David Biddulph

"Curtis Stevens" wrote in message
...
A1 = Street number like 1234
B1 = Street name like lake wood drive

I want all records to be sorted by street name (B1) and then the records
with identical street names, to be sorted by their numbers, A1.

Thanks!
Curtis