A clever trick for filtering odd and even rows in Excel

[hacks 11]

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, referencing 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.

 

 

[TheStech 1]

aahhhh nice share m8..