1 if data starts in row 1. Anyway, it's working so thanks for the feedback.

"Chris" wrote:

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