Array formula in B2:
copied down as far as needed.
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
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range
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
Counts the number of cells within a range that meet the given condition
Returns the largest value in a set of values. Ignores logical values and text.
Changes FALSE to TRUE or TRUE to FALSE
Returns the number of characters in a text string