M
Mr. Low
Hi,
May I know how to fill up group of odd numbers in sequence in Column B , C
and D ?
Illustration:
A B C D
1 xxx 1 1 1
2 xxx 1 1 1
3 xxx 3 1 1
4 xxx 3 3 1
5 xxx 5 3 3
6 xxx 5 3 3
7 xxx 7 5 3
8 xxx 7 5 3
9 xxx 9 5 5
What formula I must input at cell B1, C1 and D1 before copy downwards to get
the numbers ?
Thanks
Low
May I know how to fill up group of odd numbers in sequence in Column B , C
and D ?
Illustration:
A B C D
1 xxx 1 1 1
2 xxx 1 1 1
3 xxx 3 1 1
4 xxx 3 3 1
5 xxx 5 3 3
6 xxx 5 3 3
7 xxx 7 5 3
8 xxx 7 5 3
9 xxx 9 5 5
What formula I must input at cell B1, C1 and D1 before copy downwards to get
the numbers ?
Thanks
Low