Now filter for 0 in column B as it signifies the alternate rows (every second row) and press Shift+Space bar to select the entire row and delete them. =MOD(ROW(A2),3).ĭrag the formula till where the data is available in column A. MOD function gives the remainder after a number is divided by a divisor and ROW function gives the row no of the cell.Įnter the formula =MOD(ROW(A2),2) in the cell B2 ,the first argument to MOD is the row number and second argument is 2 because we want to remove every alternate rows, if we wanted to remove every third row, we would have provided 3 as second argument to MOD function i.e. We will see a simple example to understand that how we could do it with the data below. We could use the MOD and ROW function in excel to remove every alternate rows or every nth row in excel. Let’s see how we can remove each alternate rows in excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |