| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SORT A COLUMN OF NUMBERS AND HAVE THE DUPLICATES REMOVED | Excel Discussion (Misc queries) | |||
| sort and return column numbers | Excel Worksheet Functions | |||
| Sort mixed numbers/letters | Excel Discussion (Misc queries) | |||
| Incrementing Mixed text & numbers | Excel Discussion (Misc queries) | |||
| SORT MIXED DATA | Excel Worksheet Functions | |||
Hybrid Mode
