How to Filter Even or Odd Rows in Excel

This post will guide you how to filter even rows or odd rows from your data in Excel 2013/2016.

Assuming that you have a list of data in range A1:C7, and you want to filter out even rows or odd rows from those data in your worksheet. How to do it. You need to use two Helper column, one column used to calculate the row number, and another row used to check if the current row number is even or odd. Just do the following steps:

Step1: insert the first extra column at the end of the column C, and enter the number 1, and then drag the AutoFill handle until to Cell row 7.

filter even or odd rows2

Step2: click AutoFill options icon, and choose Fill series. Then each row number will be displayed in each cell of column D.

filter even or odd rows1

Step3: insert the second extra column at the end of the column D, and enter the following formula based on the ISEVEN function to check if the current row number is even or odd.  Then drag the Autofill handle down until to Cell E7.

=ISEVEN(D1)

filter even or odd rows3

Step4: keep to select column E, and go to Data tab, click Filter command under Sort & Filter group. And a filter icon will add into the Cell E1.

filter even or odd rows4

filter even or odd rows5

Step5: click filter icon to filter either TRUE or FALSE values.

filter even or odd rows6

Note: if you want to filter even values, just only checked TRUE item in the filter box. And if you want to only filter odd values, just checked FALSE item in the filter box.

filter even or odd rows7

 

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar