SORTING BY ODD OR EVEN NUMBERS
 

I have a large list of addresses, the addresses are broken down into a column
for the house number, column for the street direction, column for street
name, and a column for the street type (St, Rd, Pkwy...etc.). What I need to
accomplish is to sort this list into even numbered properties ascending then
odd numbered properties ascending is there a way to do that or at the very
least can I identify using a formulae which are odd or which are even I would
only need to choose one value because obviously the other value is going to
be false. The house number does not always have the same number of intergers.

SORTING BY ODD OR EVEN NUMBERS
 

Use the 'mod' function. If your address numbers are in column "A", then you
could place a formula like the following in some other column and drag it
down by the fill column. The function returns the word "even" if the
corresponding value in A is even and odd if the value is odd.

=IF(MOD(A1,2)=0,"even","odd")

Steve

"Singforyou1954" wrote in message
...
I have a large list of addresses, the addresses are broken down into a
column
for the house number, column for the street direction, column for street
name, and a column for the street type (St, Rd, Pkwy...etc.). What I need
to
accomplish is to sort this list into even numbered properties ascending
then
odd numbered properties ascending is there a way to do that or at the very
least can I identify using a formulae which are odd or which are even I
would
only need to choose one value because obviously the other value is going
to
be false. The house number does not always have the same number of
intergers.

SORTING BY ODD OR EVEN NUMBERS
 

Add a column for Even/Odd and use this formula
=IF(EVEN(A1)=A1,"Even","Odd")

then you can use this as one of your sort drivers.

--
If this helps, please remember to click yes.


"Singforyou1954" wrote:

I have a large list of addresses, the addresses are broken down into a column
for the house number, column for the street direction, column for street
name, and a column for the street type (St, Rd, Pkwy...etc.). What I need to
accomplish is to sort this list into even numbered properties ascending then
odd numbered properties ascending is there a way to do that or at the very
least can I identify using a formulae which are odd or which are even I would
only need to choose one value because obviously the other value is going to
be false. The house number does not always have the same number of intergers.