Sorting odd/even numbers

[peterguy]

I have several hundred rows of data that I need to sort by the ID numbers which are either odd or even. How do I do this?

Thanks for your help.

PS If not totally obvious, I am a casual Excel user and this is totally outside of my realm of experience!

 

[zacemmel]

Add another column and use the isodd and iseven functions.

 

[peterguy]

Thank you.

I don't know if I screwed it up somehow, but in order to get it to sort on true/false, I added another column and had the true/false put into it and sorted on that column. BUT IT WORKED!