Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting numbers and numbers that contain text in excel | Excel Discussion (Misc queries) | |||
Sorting Numbers | Excel Discussion (Misc queries) | |||
Sorting high numbers from low numbers between two rows | New Users to Excel | |||
Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
Sorting numbers with differing numbers of digits | Excel Discussion (Misc queries) |