You can use the following basic formula to select every nth row in Excel: =OFFSET($A$1,(ROW()-1)*n,0). This formula selects every nth row.
確定! 回上一頁