Forum Discussion
Solved
Creating a number range omitting certain numbers
Hi
I am trying to create a number range that will omit every 7th number i.e 1,2,3,4,5,6,8,9,10,11,12,13,15,16,17,18,19,20.
I am doing this to create a number range in excess of 14000 numbers so w...
Hi Pete,
If you fill in the first number, you could use =IF(MOD(A1+1;7)=0;A1+2;A1+1) as from the second number to exclude the multiples of 7.
Enclosed an example.
Kr
TK
Hi Pete,
If you fill in the first number, you could use =IF(MOD(A1+1;7)=0;A1+2;A1+1) as from the second number to exclude the multiples of 7.
Enclosed an example.
Kr
TK
- Thanks for the quick reply.
I have tried the formula you provided but i keep getting error messages- It is possible that you should replace the ";" by ","
- That has worked thank you so much for your help
