how do I sort a column mixed with odd and even numbers .. ?
 

Hello ,

I have a column with numbers .. I succed to sort them by descending .. but
now I want to know how I sort them separatly odd or even number !

Thank you,

Istvan.

how do I sort a column mixed with odd and even numbers .. ?
 

your numbers are in column A

=IF(MOD(A1,2)=1,A1,"")

enter this formula in column B
all the uneven numbers will show
then sort the two columns by column B

Column A will have all the uneven numbers followed by the even numbers


Greetings from New Zealand

"Istvan" wrote in message
...
Hello ,

I have a column with numbers .. I succed to sort them by descending .. but
now I want to know how I sort them separatly odd or even number !

Thank you,

Istvan.