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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select even or odd numbers 3
SORTING BY ODD OR EVEN NUMBERS 1
sort a table that contains both numbers and blank cells 1
how can I sort a column numerically with both words and numbers i. 2
Excel Sort 2
Sort mixed numbers/letters 1
Can I combine 4 columns of data into one column? 1
How to sort entire spreadsheet by one column sort 5

Top