sorting - Sort even numbers, then odd numbers -

i need sort street addresses people walk on either side of street. therefore need order address numbers first, odd numbers.

i've managed sort street name, how sort data evens , odds within streets?

make new formula called evenorodd:

tonumber({addressnumber}) mod 2 

this returns 0 when number even, , 1 when number odd. add new group inside existing group , sort based on evenorodd.