Sorting by odd and even numbers

[maday]

I am sorting by address and need to have the sort by odd number together then the even number. Can this be done?

 

[Oaktree]

Can you post a sample of your data? (Click on "Download Colo's HTML Maker..." at the bottom of this page if you haven't already downloaded the add-in)

 

[texasalynn]

you can but would have to create a column to determine odd/even. Something like this

Book3
	A	B	C	D
1	Address	Odd Number
2	226 North	FALSE
3	226 South	FALSE
4	123 North	TRUE
5	123 West	TRUE
Sheet1

HTH

 

[maday]

I went to look for the formula =ISODD and could not find it. Am I going to the wrong place?

 

[Oaktree]

ISODD is part of the analysis toolpak add-in.

You could also use =MOD(LEFT(A2,FIND(" ",A2))+0,2) instead of using ISODD

 

[maday]

I used the mod and it gave me the words #VALUE! in the column. Don't i need to have a true or false statement in the column?

 

[Pekkavee]

Is your address like this

226 North

Formula =MOD(LEFT(A2,FIND(" ",A2))+0,2)
is looking for a space " " to define numbers you have in there.

If you have only numbers so
=MOD(A2,2) could work

Pekka

 

[maday]

My address are just the number in one column and then the street name in another. The =MOD(A2,2) worked. Thanks