Thread: how do I sort a column mixed with odd and even numbers .. ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Kuunders Bill Kuunders is offline
external usenet poster
  
Posts: 303
Default 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.


Reply With QuoteReply With Quote