Array Formulas

Chip Pearson, an Excel MVP, has written a helpful explanation of array formulas in Excel. His site also contains other helpful Excel tips, links, and info.