Inspired from a comment in this article Unique values from multiple columns using array formulas I have now created this article. From a range spanning multiple rows and columns  I extract a unique distinct list sorted from A-Z.

Array formula in B8:

=INDEX(tbl, SMALL(IF(SMALL(IF(COUNTIF($B$7:B7, tbl)=0, COUNTIF(tbl, "<"&tbl)+1, ""), 1)=COUNTIF(tbl, "<"&tbl)+1, ROW(tbl)-MIN(ROW(tbl))+1), 1), MATCH(MIN(IF(COUNTIF($B$7:B7, tbl)>0, "", COUNTIF(tbl, "<"&tbl)+1)), INDEX(COUNTIF(tbl, "<"&tbl)+1, SMALL(IF(SMALL(IF(COUNTIF($B$7:B7, tbl)=0, COUNTIF(tbl, "<"&tbl)+1, ""), 1)=COUNTIF(tbl, "<"&tbl)+1, ROW(tbl)-MIN(ROW(tbl))+1), 1), , 1), 0), 1) + CTRL + SHIFT + ENTER copied as far down as necessary.

Named ranges
tbl (B2:E5)
What is named ranges?

How to implement array formula to your workbook
Change the named range. If your list starts at, for example, F3. Change $B$7:B7 in the above formulas to F2:$F$2.

Download excel sample file for this tutorial.
extract-a-unique-distinct-list-sorted-A-Z-from-a-range.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

COUNTIF(range,criteria)
Counts the number of cells within a range that meet the given condition

SUM(number1,[number2],)
Adds all the numbers in a range of cells

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

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

SMALL(array,k) Returns the k-th smallest row number in this data set.

This blog article is one out of thirteen articles on the same subject "unique".

• How to extract a unique distinct list from a column in excel
  
• Extract a unique distinct list from two columns using excel 2007 array formula
  
• Extract a unique distinct list from three columns in excel
• Extract distinct unique sorted year and month list from a date series in excel
  
• Create a unique distinct list from a date range in excel
  
• Unique values from multiple columns using array formulas
  
• Extract a unique distinct list sorted from A-Z from range in excel
  
• Sort a range by occurence using array formula in excel
  
• Filter unique distinct values from two ranges combined in excel 2007
• Create a unique list and sort by occurrances from large to small
  
• Unique list to be created from a column where an adjacent column has text cell values
  
• Create unique list from column where an adjacent column meets criteria
  
• How to create a unique distinct list where other columns meet two criteria

Related posts:

1. Extract a unique distinct list sorted alphabetically removing blanks from a range in excel
2. Unique distinct list from a column sorted A to Z using array formula in excel
3. Unique distinct list sorted based on occurrance in a column in excel
4. Filter unique distinct list sorted based on sum of adjacent values using array formula in excel
5. Create unique distinct list sorted based on text length using array formula in excel
6. Filter a column and create a new unique list sorted from A to Z using array formula in excel
7. Create a unique distinct sorted list containing both numbers text removing blanks in excel
8. Create a unique distinct text list from a range containing both numerical and text values in excel
9. Validate unique distinct list in excel