i finding weirdly hard explain want perform rows automatic fill operation in excel , having problem. have these rows:
1 = a1 2 = d1 3 = g1 4 = j1 5 = m1 6 = o1 i want repeat sequence 7 = a2, 8 = d2 etc. auto fill completes 7 a7, 8 d7, 6 cell step insted of 1.
what doing wrong?
i solved using offset: =offset(sheet1!aa$2;p6;0) p:p column filled numbers this: 1,1,1,1,1,1,2,2,2,2,2,2,3,3,3,3,3,3 etc.
Comments
Post a Comment