Simplify equation
In B2 enter the below and copy to the right as required...
=MOD(COLUMN(F1),6)+2
If this post helps click Yes
---------------
Jacob Skaria
"Stephen Christian" wrote:
Cna someone simplify this for me please? Starting at b2
=IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6))))
so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2
Thanks
|