How to Sort Odd and Even Numbers in Excel (4 Easy Examples)

If you want to sort odd and even numbers in Excel, you have come to the right place. Here, we will walk you through 4 easy and effective examples to do the task smoothly.

Download Practice Workbook

You can download the Excel file and practice while reading this article.

4 Suitable Examples to Sort Odd and Even Numbers in Excel

In the following dataset, you can see the Name and Code No. column. Here, you can easily notice that Code No. column contains even and odd numbers. Further, using this dataset, we will go through 4 easy examples to sort odd and even numbers in Excel. Here, we used Excel 365. You can use any available Excel version.

1. Using ISODD Function to Sort Odd and Even Numbers in Excel

In this method, we will use the ISODD function to sort odd and even numbers in Excel.
Here, we have added a Helper Column in the dataset where we will use the ISODD function.

Steps:

• In the first place, we will type the following formula in cell D5.

• At this point, press ENTER.
• Therefore, you can see the result in cell D5.
• Furthermore, we will drag down the formula with the Fill Handle tool.

• Hence, you can see the complete Helper Column.

• Now, we will sort the TRUE and FALSE from A to Z. Therefore, Code No. will be sorted as odd and even numbers.
• To do so, we will select the entire Helper Column by selecting cells D5:D14.
• In addition, we will go to the Home tab >> select Editing.
• Furthermore, from Sort & Filter >> select Sort Smallest to Largest.
• Here, you can select Sort Largest to Smallest if you want to sort Z to A.

• At the moment, a Sort Warning will appear.
• Then, make sure Expand the selection is marked.
• After that, click on Sort.

• As a result, you can see the whole dataset has been sorted.
• Hence, you can see the sorted odd and even numbers in Code No. column.

Read More: How to Check If a Number Is Odd in Excel (3 Easy Ways)

2. Use of IF, ISODD, and ISEVEN Functions to Sort Odd and Even Numbers in Different Columns

In this method, we will use the combination of the IF and ISODD functions to sort the odd numbers. And, we will use the combination of the IF and ISEVEN functions to sort the even numbers.

Steps:

• First, we will sort the odd numbers.
• Therefore, we will type the following formula in cell D5.

• At this point, press ENTER.
• Therefore, you can see the output in cell D5.
• Moreover, we will drag down the formula with the Fill Handle tool.

•  Therefore, you can see the sorted odd numbers in the Odd Numbers column.

• Further, we will sort the even numbers.
• To do so, we will type the following formula in cell E5.

• After that, press ENTER.
• Therefore, you can see the result in cell E5.
• Furthermore, we will drag down the formula with the Fill Handle tool.

• Therefore, you can see the sorted even numbers in the Even Numbers column.

Read More: How to Verify Odd and Even Using IF Function in Excel

3. Sorting Odd and Even Numbers in an Ascending Order

In this method, we will use the combination of IFERROR, IF, ROW, INDEX, MOD, and SMALL functions to sort odd and even numbers in Excel. This method is helpful when you want the odd or even numbers to be sorted in ascending order.

Steps:

• In the beginning, we will type the following formula in cell D5.

• In addition, press ENTER.
• Therefore, you can see the result in cell D5.
• Furthermore, we will drag down the formula with the Fill handle tool.

• Hence, you can see the complete Odd Numbers column.

• Afterward, to sort the even number, we will type the following formula in cell E5.

• Here, the formula has only one difference from the previous one.
• We take MOD($C$5:$C$14,2)=0 because we want to get the even numbers, and therefore, we want the reminder to become 0.

• At this point, press ENTER.
• As a result, you can see the output in cell E5.
• Furthermore, we will drag down the formula with the Fill Handle tool.

• As a result, you can see the complete Even Numbers column.

Read More: How to Fill Odd Numbers in Excel (5 Suitable Examples)

4. Inserting ISODD and MID Functions to Sort Odd and Even Numbers Between Texts

In the following dataset, you can see Code No. column contains both text and numbers. Here, we want to sort the even and odd numbers based on the middle number of the text. We will use the ISODD and MID functions for this case.

Steps:

• First, we need a Helper Column to perform our calculation.
• Then, we will type the following formula in cell C5.

•  Then, press ENTER.
• Hence, you can see the result in cell D5.
• Moreover, we will drag down the formula with the Fill Handle tool.

• Hence, you can see the complete Helper Column.

• Now, we will sort the TRUE and FALSE from A to Z. Therefore, Code No. will be sorted as odd and even numbers.
• To do so, we will select the entire Helper Column by selecting cells D5:D14.
• In addition, we will go to the Home tab >> select Editing.
• Furthermore, from Sort & Filter >> select Sort Smallest to Largest.
• Here, you can select Sort Largest to Smallest if you want to sort Z to A.

• At the moment, a Sort Warning will appear.
• Then, make sure Expand the selection is marked.
• After that, click on Sort.

• Therefore, you can see the sorted Code No. column, where the middle number of the text strings has been sorted according to the even and odd numbers.

Read More: Excel Formula for Finding Odd or Even Numbers

Practice Section

You can download the above Excel file and practice the explained examples.

Conclusion

Here, we show you 4 easy examples to sort odd and even numbers in Excel. Thank you for reading this article. We hope it was helpful. If you have any queries, please let us know in the comment section. You can visit our website Exceldemy for more related articles.

Related Articles

• How to Use ODD Function in Excel (3 Examples)
• Separate Odd and Even Numbers in Excel (6 Handy Ways)