addresses

[G_Jeff365]

does anyone know how to sort a column of street addresses by "odd" or "even"?

[#2]

@G_Jeff365 If they're simple addresses you could do something like this:

[#3]

@G_Jeff365   assume for the basis of this answer that the street address begins in column A, row 2 (i.e., cell A2) the following formula in B2 will return the value "Even" or "Odd" based on the street number. But this will only work where the address BEGINS with the number. Since that covers the vast majority of situations, I'll assume you can manually deal with any outliers.

Here's the formula: =IF(MOD(LEFT(A2,FIND(" ",A2)-1),2)=0,"Even","Odd")

You can then sort on the column containing those words.

[#4]

This is cleaner than mine.