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
Invert_list_start (A4)
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
invert-a-list-using-cell-references.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

IF(logical_test;[value_if:true];[value_if_false])
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

INDIRECT(ref_text,[a1])
Returns the reference specified by a text string

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

Related posts:

1. Invert a list using named ranges
2. Invert a list ignoring blanks in excel
3. Create and sort distinct list by adjacent cell value size
4. Create a list of distinct values from a list where an adjacent cell value meets a criteria in excel
5. Sort cell values into categories, part 2
6. Merge two columns into one list in excel
7. Unique list to be created from a column where an adjacent column has text cell values
8. Group similar cell values on same row in excel
9. Merge two lists
10. Merge three columns into one list in excel