Excel - Second Level Sort

Asked By julsenso on 06-Sep-10 12:09 PM
Office Excel 2007

Second level sort not rendering

I have a  name address etc wksht where the street number is one column
and the street name is another column

I set the first sort on street name and the second level sort to
street # .

The street name sorts fine but the street numbers do not order
correctly so that instead of getting 123 xyz st then 125 xyz st  and
345 xyz st, the numerical part of the address is not sequential.




Jim Cone replied to julsenso on 06-Sep-10 01:04 PM
Run two separate sorts: first sort the numbers then sort the names.
--
Jim Cone
Portland, Oregon  USA
http://www.contextures.com/excel-sort-addin.html

.
.

Office Excel 2007

Second level sort not rendering

I have a  name address etc wksht where the street number is one column
and the street name is another column

I set the first sort on street name and the second level sort to
street # .

The street name sorts fine but the street numbers do not order
correctly so that instead of getting 123 xyz st then 125 xyz st  and
345 xyz st, the numerical part of the address is not sequential.
Ron Rosenfeld replied to julsenso on 06-Sep-10 03:40 PM
I cannot reproduce your problem by doing a sort as you describe.

Could you give some examples?

Is it possible that your numbers are text representations and not
really numeric?