Excel Function : MOD
Category
Math and trigonometry
Description
Returns the remainder from division
Microsoft Excel Reference Page
https://support.office.com/en-us/article/MOD-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3
Syntax and Description of the MOD Excel Function
I am using this formula to pull data from an excel sheet using the MOD function.
=MOD(ROW(A1:A6)-ROW(A1),6)+1
This formula works fine if I want to pull 6 rows at a time. But I want to pull 2 rows at a time. How can I change this formula to pull 2 rows at a time?
A:
For two rows at a time, you need to change your modulus to 2.
=MOD(ROW(A1:A6)-ROW(A1),2)+1
About MOD Excel Function
The MOD function returns the remainder after a number is divided by a divisor. For example, MOD(9,3) equals 0 because 3 goes into 9 evenly nine times with no remainder. However, MOD(10,3) equals 1 because 3 goes into 10 seven times, with a remainder of 1.