Here is one way... In B2 enter

=IF(OR(COLUMN()=2,A2=7),2,A2+1)

and copy across row 2 as needed.

Hope this helps,

Hutch

"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