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
 

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

(headers & footers Issue) I have 2 even pages back to back!! 1
How can the font and size of (all) citation numbers be altered? 1
SORTING BY ODD OR EVEN NUMBERS 2
Excel does not accept text format! 0
Book formatting: need to alternate page number on left and right margin for only first page of each 2
Select even or odd numbers 4
Sorting a column based on required order 2
Can I combine 4 columns of data into one column? 1

Top