Excel 2004 for Mac Solution Center

Functions

How to use the INDEX and MATCH worksheet functions with multiple criteria in Excel
Describes how to use the INDEX and MATCH worksheet functions in Excel to find a value based on multiple criteria. This article also provides some examples to show how to perform this task.
Description of improvements in the statistical functions in Excel 2003 and in Excel 2004 for Mac
Describes the improved statistical functions in Excel 2003 and in Excel 2004 for Mac. Compares the functions in these versions with the functions in earlier versions of Excel.
How to determine the number of unique items in a list in versions 97, 2000, and 2002 of Excel
Provide two methods that you can use to count the unique items in a list in Excel . The method determines whether the list contains blank entries. Requires that you use the SUM, COUNTIF, and LEN functions.

Description of the Microsoft Office 2004 for Mac 11.1.1 Update
Discusses the Microsoft Office 2004 for Mac 11.1.1 Update. This update addresses several issues with Microsoft Excel 2004 for Mac, PowerPoint 2004 for Mac, and Visual Basic for Applications in Office 2004 for Mac.
MS08-014: Vulnerabilities in Microsoft Excel could allow remote code execution
Resolves reported vulnerabilities in Microsoft Excel that could allow remote code execution.
Description of the Microsoft Office 2004 for Mac Service Pack 1 (11.1.0)
Discusses the Microsoft Office 2004 for Mac Service Pack 1 (11.1.0). This service pack addresses several security and stability issues in Office 2004 for Mac programs.
Description of Microsoft Office 2004 for Mac Service Pack 2 (11.2.0)
Describes Microsoft Office 2004 for Mac Service Pack 2 (11.2.0). This service pack addresses several security and stability issues in Office 2004 for Mac programs.

You may obtain incorrect results and misleading labels when you use the Analysis ToolPak t-Test in Excel
Explains the fact that the Analysis ToolPak t-Test may return incorrect results when you use it in Excel. You may also notice that the labels in the output are misleading. Suggests using Excel functions to duplicate most of the tool's functionality.
Incorrect output is returned when you use the Linear Regression (LINEST) function in Excel
Discusses a problem in which the incorrect output is returned when you use Linear Regression (LINEST) function in Excel.
The LINEST function returns incorrect results in Excel
When you use the LINEST statistical worksheet function in Microsoft Excel, the formula may return an incorrect result.