I have a Excel97 problem I was hoping
someone may be able to help with.
This is what I want it to do:
_____A_______B___________C_______D_______E
1__31-32___Week 1______31-32___33-34___35-36
2__35-36___Week 2______Week 1__________Week 2
3__31-32___Week 3______Week 3__________Week 4
4__35-36___Week 4
5__________Week 5
6__________Week 6
I want column A's numbers to report to their proper place in C,D,and E as they are entered. But, with the formula I am using it won't fill in Week 3 in Column C until I enter 31-32 for a third time in Col A.
(same problem with Week 4)
It is always one entry behind.
I am using the formula:
=(IF(ROW()>COUNTIF($A$1:$A$29,C$1),"",INDIRECT("B"&SMALL(IF($A$1:$A$29=C$1,ROW($A$1:$A$29)),ROW(A1)))))
it is array entered and filled down.
What did I do wrong?
I am completely out of ideas on this one.
Thanks for your help,
JP
This message was edited by JP on 2002-09-05 10:01
someone may be able to help with.
This is what I want it to do:
_____A_______B___________C_______D_______E
1__31-32___Week 1______31-32___33-34___35-36
2__35-36___Week 2______Week 1__________Week 2
3__31-32___Week 3______Week 3__________Week 4
4__35-36___Week 4
5__________Week 5
6__________Week 6
I want column A's numbers to report to their proper place in C,D,and E as they are entered. But, with the formula I am using it won't fill in Week 3 in Column C until I enter 31-32 for a third time in Col A.
(same problem with Week 4)
It is always one entry behind.
I am using the formula:
=(IF(ROW()>COUNTIF($A$1:$A$29,C$1),"",INDIRECT("B"&SMALL(IF($A$1:$A$29=C$1,ROW($A$1:$A$29)),ROW(A1)))))
it is array entered and filled down.
What did I do wrong?
I am completely out of ideas on this one.
Thanks for your help,
JP
This message was edited by JP on 2002-09-05 10:01
