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.
Could you just sort the data, as an alternative to using formulas?
- Jon
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.