Sorting odd/even numbers

peterguy · May 7th, 2002, 02:56 PM

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 · May 7th, 2002, 03:00 PM

Add another column and use the isodd and iseven functions.

peterguy · May 7th, 2002, 03:16 PM

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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 02:56 PM	#1
peterguy New Member Join Date: May 2002 Posts: 2	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!

May 7th, 2002, 03:00 PM	#2
zacemmel Board Regular Join Date: Apr 2002 Location: Redmond, WA Posts: 636	Add another column and use the isodd and iseven functions.

May 7th, 2002, 03:16 PM	#3
peterguy New Member Join Date: May 2002 Posts: 2	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!