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?

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"russianblue" wrote:
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?

Another way:

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

--
Biff
Microsoft Excel MVP


"Max" wrote in message
...
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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"russianblue" wrote:
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?

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"russianblue" wrote in message
...
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?