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

I

Istvan

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.
 
B

Bill Kuunders

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
 
Top