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.