Don't know if this is the one you're talking about, but here's a reversing
formula using Index:

=INDEX($A$1:$A$20,20-(ROW(A1)-1))

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Chris" wrote in message
...
Ah thank you, just what I was looking for. Except in your formula it
should
be +1 not +2. It's amazing the various ways you can write a formula in
Excel. I think I asked this question about a month ago and someone told
me
how to write the formula using the index function.

Thanks again.


"Toppers" wrote:

Assuming data in column starting row 2, and with no embedded blanks, then
in
B2 put:

=INDIRECT("A" & COUNTA(A:A)+2-ROW())

HTH

"Chris" wrote:

0
1
2
3
4
5

I would like

5
4
3
2
1
0