## Reverse a list ignoring blanks in excel

### Reverse a list ignoring blanks

Formula in C2:

copied down as far as necessary.

**Named ranges**

List (A2:A13)

What is named ranges?

**How to implement array formula to your workbook**

Change named range. Change $C$1:C1 to your start cell of your new list.

Download excel example file.

Invert a list ignoring blanks.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

**INDEX(**array,row_num,[column_num]**)**

Returns a value or reference of the cell at the intersection of a particular range

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

**LARGE(**array,k**)** returns the k-th largest row number in this data set

**MIN(**number1,[number2]**)**

Returns the smallest number in a set of values. Ignores logical values and text

Create a list of dates with blanks between quarters in excel

Question: How do I create a list of dates with blanks between each quarter? (Q1, Q2, Q3 and Q4) Answer: […]Find positive and negative amounts that net to zero in excel

I found this excel question: I am a Controller in a multinational company. We have many transactions (sales, credits, debits, […]Extract unique distinct values from a filtered table (udf and array formula)

Robert Jr asks: Oscar, I am using the VBA code & FilterUniqueSort array to generate unique lists that drive Selection […]Sort text cells alphabetically from two columns using excel array formula

Table of Contents Sort text from two columns combined (array formula) Sort text from multiple cell ranges combined (user defined […]