Hello. Excel 2007.
I know that I can create a formula that reverses the order of a column of data. Does anyone have this example to hand?
(I know that the best way would be to sort it in Descending order?!) Thanks ,Andy.
Reverse the order of a list
-
agibsonsw
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Reverse the order of a list
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
HansV
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Reverse the order of a list
Let's say your list is A2:A8.
In B2, enter the formula
=INDEX($A$2:$A$8,9-ROW())
Fill down to B8.
In B2, enter the formula
=INDEX($A$2:$A$8,9-ROW())
Fill down to B8.
Best wishes,
Hans
Hans
-
agibsonsw
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Reverse the order of a list
Thank you - nice formula.
Andy.
Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.