sorting, odd - even ?

[excel rookie]

I am trying to sort the ending number of addresses by odd & even. These addresses are all in a column is it possibe to do this ? I have tried the auto filter with no luck ?

[Bryan Hessey]

I am trying to sort the ending number of addresses by odd & even. These addresses are all in a column is it possibe to do this ? I have tried the auto filter with no luck ?

Hi,

Easiest will be a 'helper' column, where the column indicates 1 for odd and zero for even, sort over helper then over other columns as required.

hth
---

[excel rookie]

sorry I dont understand ? I am new to excel.

[Bryan Hessey]

sorry I dont understand ? I am new to excel.

What column is your addresses in, and do all addresses have numbers at the start followed by a space.

Do you want to sort any without numbers as odd or even?

---

[excel rookie]

address numbers are all in column A and I want to sort them all by the ending number of the street address by odd or even

[Bryan Hessey]

address numbers are all in column A and I want to sort them all by the ending number of the street address by odd or even

OK - insert a new column B (if column B is not blank)
in B1 put

=IF(ISERROR(RIGHT(TRIM(LEFT(A1,FIND(" ",A1))),1)),"",MOD(RIGHT(TRIM(LEFT(A1,FIND(" ",A1))),1),2))

you can copy that, the two red bits have spaces, any other spaces are web faults.

formula fill that down as far as you have data in column A
formula fill is described at
http://www.mvps.org/dmcritchie/excel/fillhand.htm

then Copy column B and Paste, Special = Values back over itsself.

Then sort All Data over column B, and then over your other columns as required.

After you have sorted you can delete column B

Let me know how you go.

---


noted that I could have used a Mid for 1 character with space find - 1 and space find