Help needed

[Roy]

At work we run 4 production Teams; Team 1 thru Team 4. Each Team is
assigned a production schedule every week. There are a total of 23 possible
production schedules, each one different.
Every week the various production schedule number (1 - 23) is recorded in a
column under the Team's number. The sequence of the schedules is erratic,
that is the same team could have the same schedule in two consecutive weeks;
or could go from schedule 8 to schedule 15. At the leftmost column is the
date.

What I need to do is, on another worksheet, enter a row of numbers 1 - 23.
Under each number I need a formula that will look at all the various
production schedules, in total, and tell me how many weeks it's been since
that particular schedule was run. An example is below. It does not need to
be by team, just the weeks since a particular schedule was run.

1 2 3 4
10/04/03 15 22 14 9
10/11/03 5 11 22 17
10/18/03 4 6 21 23
10/25/03 7 12 21 19


Thanks in anticipation

 

[Roy]

Thanks Alan

I've done as you've suggested but it doesn't seen to return the correct
number of weeks since a particular schedule run. As an example in cell B2,
I've entered 6 - but the value returned in cell I7 is 2. Where I would have
expected 3. Since it's been 3 weeks since last produced.