Article updated on February 28, 2014

Question: How do I invert / reverse a list using named ranges? My list has a named range Some_list (D3:D7), see picture below.


Answer: See picture below.

Formula in A4:A33:

=IF(ROWS(Some_list)-ROW()+ROW(Invert_list_start)>=1, INDEX(Some_list, ROWS(Some_list)-ROW()+ROW(Invert_list_start)), "") + CTRL + SHIFT + ENTER


Named ranges
Some_list (D3:D7)
What is named ranges?

How to change a named range
Click on "Name manager" on tab "Formulas" in excel 2007. Then change named ranges.

Download excel example fileinvert-a-list-using-named-ranges.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

ROW(reference) returns the rownumber of a reference

Returns the reference specified by a text string

ROWS(array) returns the number of rows in a reference or an array