Search the Community
Showing results for tags 'Excel'.
Found 1 result
-
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.
