You're welcome, Elizabeth, but you original example only showed two

adjacent time periods, so I thought you meant you only wanted the

first and the last period to be returned from the formula. If, indeed,

you need things like:

"10, 1, 2, 3" or "3, 4, 5, 6, 7" or even "7, 8, 9, 10, 1, 2, 3, 4, 5,

6"

to be returned, covering each time period within the span, then the

formula at present will not do this. You could do this by having

another table which would list all possible outcomes from the current

formula and in the next column what you would like each one to be

shown as and then use another VLOOKUP formula to do this

"translation".

Suppose you started in cell Z1 - you would first of all list the

simplest output from the current formula, i.e.:

1

2

3

4

5

6

7

8

9

10

and then follow with the next simplest (adjacent pairs), i.e.:

1, 2

2, 3

3, 4

4, 5

5, 6

and so on up to:

9, 10

10, 1

Following on from this in the same column you could have values which

are two codes apart:

1, 3

2, 4

3, 5

4, 6

and then three codes apart:

1, 4

2, 5

3, 6

and so on. The order is not important, but by adopting a systematic

approach like this you could ensure that you cover them all. Then in

column AA you could list what you want these to be transformed into,

so in the middle of the table you would have something like this:

1, 4 1, 2, 3, 4

2, 5 2, 3, 4, 5

3, 6 3, 4, 5, 6

and do this all the way down to complete the table.

Your new formula would be something like this:

=VLOOKUP(C2,Z:AA,2,0)

where C2 is the cell with the current formula. If you copy this down

then you will get the output you require. If you want to, you could

combine both formulae into one, so that you would end up with:

=VLOOKUP(VLOOKUP(A2,X$1:Y$11,2)&IF(VLOOKUP(B2,X$1:Y$11,2)<>VLOOKUP(A2,X

$1:Y$11,2),", "&VLOOKUP(B2,X$1:Y$11,2),""),Z:AA,2,0)

and this will give you the required output directly when copied down.

If you think this is too much trouble, and you don't have a lot of

data that spans multiple time periods, then you can always make the

necessary changes to the output manually.

Hope this helps, and hope you get your project in on time.

Pete