How-To Geek on MSN

You need to know the difference between a range and an array in Excel

Excel processes the range (A1:A10) by converting it into an array in memory. This array is what Excel works with to calculate the sum. The distinction is subtle but important: while the range is the ...
JournalofAccountancy

Microsoft Excel: More Dynamic Arrays functions

In addition to the new SORT function, you may also find the new FILTER and UNIQUE array functions useful. For example, the worksheet on the next page contains a detailed listing of invoices in columns ...