# Sorting by odd and even numbers

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

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

you can but would have to create a column to determine odd/even. Something like this
Book3
ABCD
2226 NorthFALSE
3226 SouthFALSE
4123 NorthTRUE
5123 WestTRUE
Sheet1

HTH

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

ISODD is part of the analysis toolpak add-in.

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

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?

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

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

Replies
5
Views
311
Replies
11
Views
243
Replies
10
Views
633
Replies
1
Views
116
Replies
7
Views
204

1,203,620
Messages
6,056,335
Members
444,861
Latest member
B4you_Andrea

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back