Excel’s filtering feature is powerful and the new table-filtering feature offers even more. However, there’s one thing neither can do: neither can filter a data set by odd or even rows. Fortunately, it’s easy to do. Simply add an extra column to the data set as follows and filter by the results:
- In an adjacent column, use the =ISEVEN() or =ISODD() function, combined with a ROW() function that references any cell in that row.
- Double-click the cell’s fill handle to copy the formula to the remaining range.
Next, enable a simple filter by selecting any cell in the data range and clicking Filter in the Sort & Filter group on the Data tab.
Click the new column’s filter dropdown and choose False or True. False will display odd rows; True will display even rows.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays