With 1 million rows available in Excel 2007, an array formula that references a whole column is extremely slow to calculate. Use Excel 2007 Structured References where you can to keep the number of cells that are evaluated by the array formula to a minimum.