Excel 2002: How to fill group of of odd number in sequence ?
James wrote to Kassie on Sat, 28 Mar 2009 12:17:39 -0400:
You cannot use formulae in row 1, so fill B1:D1 with 1's
In B2 enter =IF(COUNTIF($B$1:B1,B1)1,B1+2,B1)
In C2 enter =IF(COUNTIF($C$1:C1,C1)2,C1+2,C1)
In D2 enter =IF(COUNTIF($D$1:D1,D1)3,D1+2,D1)
:D8 and copy down
"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 ?
Am I being dumb? If you put 1, 3, 5 in B1, B2 and B3 and pull
down you will get 1, 3, 5, 7 etc. It's not much effort to do
it for the other columns.
Yes, I was being dumb since the exact squence was wanted!
--
James Silverton
Potomac, Maryland
Email, with obvious alterations: not.jim.silverton.at.verizon.not
|