All articles with 'reverse' Tag
{ 30 Comments }
Reverse a List using Formulas [Using Excel INDEX() Formula]
Published on Nov 19, 2009 in Excel Howtos, Learn Excel
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 »