Reverse Time Series Order

[russianblue]

How do I reverse the order of time series data from the current value being
first and the last value being first with all in between similarly changed?

 

[Max]

Let's say you have 10 data values in A2:A11
You could place in say, B2:
=INDEX($A$2:$A$11,11-ROWS($1:1))
and copy B2 down to B11 to reverse it.
Adapt to suit.

 

[T. Valko]

Another way:

=INDEX(A$2:A$11,ROWS(A2:A$11))

 

[Max]

Dismiss my suggestion, use Biff's much better:

=INDEX(A$2:A$11,ROWS(A2:A$11))

(Haven't had much luck with where to place my "$" recently <g>)

---

 

[Jon Peltier]

Could you just sort the data, as an alternative to using formulas?

- Jon