To Repeat a sequence of number, we could use MOD function for it.
For Example , We need a column of sequence 1,2,3,4,5 and then start from 1,2,3,4,5 and so on..
For that use formula :
C4 = MOD(C3,5)+1, Where C3 is blank .
Drag down the formula ..
MOD function (MOD( number , divisor ) >> returns the remainder after a number is divided by a divisor.
In our example 5 is the divisor, when number reaches to 5 in C9 cell , it make it zero and since we are adding it with 1, our series again started it with one.
Thanks
For Example , We need a column of sequence 1,2,3,4,5 and then start from 1,2,3,4,5 and so on..
For that use formula :
C4 = MOD(C3,5)+1, Where C3 is blank .
Drag down the formula ..
MOD function (MOD( number , divisor ) >> returns the remainder after a number is divided by a divisor.
In our example 5 is the divisor, when number reaches to 5 in C9 cell , it make it zero and since we are adding it with 1, our series again started it with one.
Thanks
No comments:
Post a Comment