MS Excel Question

[ok_cpu]

Is there a way to sort a column into odd and even numbers? I've checked the help section and played with some "if" formulas, etc. but I can't figure it out.

I've got a buddy coming to help me with a primary election walking list and it would be a big help to separate the sides of each street.

Thanks in advance. I'm off to mow right now. I'll check back in a bit.

[GirlinContempt]

1. Sorry

Looked just now, I guess you can't.

[blueworld]

2. A couple of ways, I guess

One is to use the functions ISODD or ISEVEN in an adjacent column. The function ISODD will return "true" if the number is odd, for example. If you want to sort column A, type the function in column B & sort the result, then copy down.

I also found this entry for you, which seems to have a second way of doing it.
http://www.pcreview.co.uk/forums/thread-1795064.php

I hope this helps & doesn't just cause confusion!