Hi Bernie,

Thanks, your formula works.

Best Regards

Low

--
A36B58K641


"Bernie Deitrick" wrote:

Low,

Enter 1s in B1:D1, then use one formula, entered in B2:

=IF(COUNTIF(B$1:B1,B1)=COLUMN(),B1+2,B1)

and copy across and down.

HTH,
Bernie
MS Excel MVP



"Mr. Low" wrote in message
...
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