Array formula in B2:

=IF(ROWS(B2:$B$2)>ROWS(List), "", INDEX(List, MATCH(LARGE((LEN(List)&","&ROW(List))*1, ROWS(B1:$B$1)), (LEN(List)&","&ROW(List))*1, 0))) + CTRL + SHIFT + ENTER copied down as far as needed.

Named ranges
List (A2:A19)
What is named ranges?

How to customize the formula to your excel spreadsheet
Change the named range. If your unique list starts at F3, change B1:$B$1 in the above array formula to $F$2:F2

Download excel sample file for this tutorial.
Sort text values by length.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

MATCH(lookup_value;lookup_array; [match_type]
Returns the relative position of an item in an array that matches a specified value

INDEX(array,row_num,[column_num])
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

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

MAX(number1,[number2],)
Returns the largest value in a set of values. Ignores logical values and text.

NOT(logical)
Changes FALSE to TRUE or TRUE to FALSE

LEN(text)
Returns the number of characters in a text string

Related posts:

1. Create unique distinct list sorted based on text length using array formula in excel
2. Identify largest text value in a column using array formula in excel
3. Extract numbers and text from a range using array formula in excel
4. Sort text cells alphabetically from two columns using excel array formula
5. Filter unique rows and sort by date using array formula in excel
6. Sort a range by occurence using array formula in excel
7. Filter duplicate rows and sort by date using array formula in excel
8. Filter common text values in range 1 and in range 2 using array formula in excel
9. Filter unique distinct text values using “begins with” criterion in a range using array formula in excel
10. Filter text values existing in range 1 but not in range 2 using array formula in excel