You’ll be able to usefulness please see plain system to choose each and every nth row in Excel:
=OFFSET($A$1,(ROW()-1)*n,0)
This system selects each and every nth row.
Merely trade the price for n within the system to choose explicit rows.
As an example, you’ll be able to usefulness please see system to choose each and every third row:
=OFFSET($A$1,(ROW()-1)*3,0)
Refer to examples display how one can usefulness this system in observe.
Instance: Choose Each and every Nth Row in Excel
Think we now have please see checklist of values in Excel:
We will be able to usefulness please see system to choose each and every 3rd row from the checklist:
=OFFSET($A$1,(ROW()-1)*3,0)
We can kind this system into mobile C1 and later book and paste it to the residue cells in column C:
Realize that each and every 3rd row has been decided on from the checklist of latest values:
If we alter the price of n within the system, we will be able to make a selection a unique nth worth.
As an example, we will be able to usefulness please see system to choose each and every 5th row from the checklist:
=OFFSET($A$1,(ROW()-1)*5,0)
We can kind this system into mobile C1 and later book and paste it to the residue cells in column C:
Realize that each and every 5th row has been decided on from the checklist of latest values:
Supplementary Sources
Refer to tutorials give an explanation for how one can carry out alternative regular operations in Excel:
Find out how to Delete Filtered Rows in Excel
Find out how to Depend Filtered Rows in Excel
Find out how to Sum Filtered Rows in Excel
