SORTING BY ODD OR EVEN NUMBERS

S

Singforyou1954

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.
 
P

Paul C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top