Array not working as planned, HELP!

JP

New Member
Joined
May 30, 2002
Messages
3
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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,144,122
Messages
5,722,613
Members
422,447
Latest member
knopp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top