![]() Now it filters every other row (Odd rows) immediately as the following screen shot shows: See the following screen shot:ģ: Select the Column E, and click the Filter button under Data tab.Ĥ: Click the Arrow in Column E, uncheck (Select All) item, and check 0 in the filter box. Now it fills the selection with 1, 0, 1….,1, 0. ![]() See the following screen shot:Ģ: Select the range of E2:E17, and click the Home > Fill > Down to copy this formula to all cells in the selection. ![]() If there is no sequence column before you data, please add it at the beginning.ġ: In a blank Column, says Column E, enter the formula of =MOD(A2,2) in Cell E2. This way requires basic sequence column at the beginning of data, and another help column. This is a tricky skill about how to filter every other row, filter every even / odd row, and filter every nth rows in Excel with Filter command.įilter even/odd rows with Kutools for Excelįilter every other row (Even or Odd rows) with formula ![]() How to filter every other row (even /odd rows) in Excel? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |