Hi,

I understand that excel can auto fill by recognizing patterns like 1,2,3,4 or 2,4,6,8. My question is can excel recognize complex patterns?

I would like B1 to B10 = to A1 and then B11 to B20 = A2 and then B21 to B30 = A3. From there I am trying to drag the fill handle down column B hoping that it will auto fill the rest. But when i do try to auto fill B31 begins by equaling to A31 and B32 to A32 etc. Is there a way to create a formula or edit the auto fill option so that it will follow my pattern?

Thanks in advance for any tips.