Question: How do I invert / reverse a list using cell references? My list is in D3:D7, see picture below.


Answer: See picture below

Formula in A4:A8:

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


Named ranges
What is named ranges?

How to customize formula to your excel workbook
Change named range to the cell where your inverted list start cell is to be.

Download excel example file
(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