Excel 2002: How to fill group of of odd number in sequence ?
M24
M25
M26
M27
M28
M29
M30
M31
M32
M33
M34
M35
M36
M37
M38
M39
M40
M41
M42
M43
M44
M45
M46
M47
M48
--
A36B58K641
"Gary''s Student" wrote:
In B1 and B2 enter 1
In B3 enter:
=IF(B2=B1,B2+2,B2) and copy down
In C1 and C2 and C3 enter 1
in C4 enter:
=IF(MIN(C1:C3)=MAX(C1:C3),C3+2,C3) and copy down
Use the column C approach to fill column D.
--
Gary''s Student - gsnu200841
"Mr. Low" wrote:
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
--
A36B58K641
|