There may be neater solutions, but until something better comes along,
you can accomplish this by using a couple of helper columns. Assuming
your data is in Column A, starting in A1, insert blank Columns B & C.
In C2 enter -1, in C3 enter -2. Highlight these two cells and drag to
the last row of the range of data in A (the numbers should decrease -3,
-4....-nnn). Then in B1 enter this formula:

=Annn [where nnn is the number of the last row in your data set, e.g.
=A4000]

In B2, enter this formula:

=OFFSET($A$nnn,C2,0) [again, nnn is the last row]

copy this formula down to row nnn

Does this work for you?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=391357