I am looking for a formula to generate the sequence down row B starting from B3. I would like the sequence to be: every fourth term +8 and the following three terms to be -1 sequentially, ie) 11,10,9,8,19,18,17,16,27,26,25,24,35,34,33,32....
Any ideas?
I have tried =IF(MOD(B3,4)=0,($B$3:B3)+8,B3-1) however this only works for the first few terms as the add 8 always occurs to B3 rather than to B7, B11... in turn