All articles with 'reverse' Tag

Reverse a List using Formulas [Using Excel INDEX() Formula]

Published on Nov 19, 2009 in Excel Howtos, Learn Excel
Reverse a List using Formulas [Using Excel INDEX() Formula]

Here is a simple yet novel use of formulas. Let us say you have a list of values in range A1:A5 and you want to reverse the list. In an empty cell write =INDEX($A$1:$A$5,6-ROWS($A$1:A1)) and copy down. Boom, you get the reversed list. Here is how the formula works: In the reversed list, first item […]

Continue »