Leading the way in Microsoft Office Development

Knowledge Base Articles - 2007

286258 - 2007: Excel RTD Function Cannot Return an Array

285339 - 2007: How To Create a RealTimeData Server for Excel

181212 - 2007: How to use the LOOKUP function with unsorted data in Excel

277617 - 2007: RTD Formula Evaluates to #N/A

291309 - 2007: Using a Worksheet Function in a Visual Basic Macro

274537 - 2007: When to Use SUM(IF()) Instead of COUNTBLANK()

Knowledge Base Articles - 2003

828129 - 2003: PEARSON

Knowledge Base Articles - 2002

284872 - 2002: #N/A Displayed in Cell with RTD Function If You Change RTD Topic

277589 - 2002: Argument in the Insert Function Dialog Box Looks Like a Hyperlink but Does Not Work

287113 - 2002: AutoSum Button Unexpectedly Returns Values from Hidden Cells in List with AutoFilter

211370 - 2002: CELL Function with 'filename' No Longer Volatile

277618 - 2002: Calling a Server by Using the RealTimeData (RTD) Function

287118 - 2002: Data Is Not Refreshed When RTD Server Is Started

131384 - 2002: EVALUATE() Function with INDIRECT() Returns #REF! Error

282146 - 2002: Excel Does Not Automatically Translate Arguments in Worksheet Functions

214076 - 2002: Formula to Calculate the Standard Error of the Mean

214116 - 2002: Formulas to Find the Log and Inverse Log of a Number

214093 - 2002: How to Display the Current Date and Time with Text

214084 - 2002: How to Display the File Name of a Worksheet Without Using a Macro

214264 - 2002: How to Perform a Case-Sensitive Lookup

214069 - 2002: How to Return the First or Last Match in an Array

030567 - 2002: IRR Returns #DIV/0! Instead of #NUM! If No IRR Exists

119083 - 2002: MOD() Function Returns #NUM! Error Value

061892 - 2002: PRODUCT Function Evaluates a Blank Cell as 1 Not Zero

060116 - 2002: Returning the Smallest Number Greater Than Zero

214286 - 2002: Some Worksheet Functions Do Not Allow Array Constants

168437 - 2002: Unable to Select Defined Names by Using Function Wizard

213476 - 2002: Unexpected Results with Mixed Text and Numbers in Lookup Table

059616 - 2002: Use of the IRR Function in Excel

Knowledge Base Articles - 2000

214111 - 2000: ATP Definition: NORMSDIST

269267 - 2000: Administrative Update Available for the Excel 2000 SR-1 REGISTER.ID Function Vulnerability

214072 - 2000: Algorithm Used for QUARTILE() Function

214050 - 2000: Basis Argument for Financial Functions

238996 - 2000: CALL Function Always Returns FALSE When Used in a Worksheet

215544 - 2000: CELL() Worksheet Function Is Not Updated Automatically As Expected

283695 - 2000: CONVERT Function Returns Incorrect Calculation for Liters and Quarts

211903 - 2000: COUNTA Function Changed to COUNT

215276 - 2000: COUNTA Function May Return Incorrect Result of 1

214322 - 2000: COUNTA Function Returns 1 with Invalid Reference Argument

231000 - 2000: COUNTIF Returns Incorrect Value When It Refers to Blank Cells

213828 - 2000: Cannot Specify Number of Digits with FIX() or INT() Functions

238482 - 2000: Cell Ranges in Aggregate Formulas May Change Unexpectedly

224183 - 2000: Certain Functions Calculate Differently in Early Versions of Excel

214331 - 2000: DATE Function Behaves Differently in Microsoft Excel 2000

214365 - 2000: DATE Function May Return #NUM! Error When Year Is 0-3

213794 - 2000: DDEREQUEST May Truncate the Results of a Query

235113 - 2000: EUROCONVERT Function Is Lost When You Save Excel Data to a Web Page

214392 - 2000: Equivalents of Lotus 1-2-3 @IPAYMT and @PPAYMT Functions

215535 - 2000: Error During Save Identifies Incorrect Cell for Function

213891 - 2000: Excel Help Example Returns Incorrect Result for ERROR.TYPE Function

215732 - 2000: Formula Using SUMIF() Worksheet Function Does Not Recalculate Sum

214053 - 2000: Formula to Sum Digits of a Number

211789 - 2000: Function Box Has Replaced Name Box and Functionality Has Changed

215214 - 2000: GAMMADIST() Worksheet Function Returns #NUM! Error

213375 - 2000: How to Return the Address of the Cell with the Largest or Smallest Value

213728 - 2000: How to Sum a Range of Cells Based on a Number Format

264850 - 2000: INDIRECT Function Using R1C1 Calculates Incorrectly If Chart Is Selected

213665 - 2000: IsDate Function Incorrectly Identifies Some Expressions

214149 - 2000: Keeping a Cumulative Total in a Column or Row

214082 - 2000: LINEST Function Returns Only One Value

209326 - 2000: LINEST Or REGRESS Error Value Occurs When X-Values Are Dependent

215559 - 2000: LINEST() Worksheet Function Returns Invalid Values

248207 - 2000: Linked Files with Lookup Functions Updated Much More Slowly Than in Earlier Versions of Excel

214271 - 2000: MOD Function and Mod Operator Return Different Values

213328 - 2000: Min and Max Functions Do Not Work Properly with Arrays

262339 - 2000: ODDFYIELD Returns #NUM with Online Help Example

214321 - 2000: OFFSET Accepts Negative Values for Height and Width

215275 - 2000: OFFSET Worksheet Function Accepts Invalid Arguments

211577 - 2000: Paste Function Buttons Are Missing in the Formula Palette

213916 - 2000: Rank Duplicate Values Sequentially in Excel 2000

231114 - 2000: SUMIF and COUNTIF Functions Return Incorrect Results When Used with Strings Longer Than 255 Characters

213182 - 2000: Sample Code to Use a Date Range with NETWORKDAYS

213429 - 2000: TEXT(MONTH(NOW())'mmm') Always Returns 'Jan'

214371 - 2000: The TDIST Function Returns #NUM! if the X Argument Is Negative

213690 - 2000: The Trend Function Works Differently in Functions Than in Macros

269252 - 2000: Update Available for the Excel 2000 SR-1 REGISTER.ID Function Vulnerability

214300 - 2000: Use the 'Most Recently Used' Category in the Function Wizard in Excel 2000

213765 - 2000: Using a Worksheet Function in a Visual Basic Macro

213917 - 2000: Using the OFFSET MATCH and MAX Worksheet Functions to Return the Last Value in a Range

214311 - 2000: VLOOKUP()/HLOOKUP() Functions Return Incorrect Value with TFE

214372 - 2000: Value Returned by Format Function May Vary Between Versions of Excel

244023 - 2000: You receive different results from the ACCRINT function in Excel 97 and in Excel 2000

Knowledge Base Articles - 1997

173553 - 1997: 'Help Topic Does Not Exist' Error in Function Wizard

103493 - 1997: Algorithm Used for QUARTILE() Function

123189 - 1997: Alternative EOMONTH Worksheet and Macro Functions

121730 - 1997: Analysis ToolPak Functions Unexpectedly Return #NAME Error Value

108725 - 1997: Basis Argument for Financial Functions

165260 - 1997: COUNTA Function Changed to COUNT

232494 - 1997: COUNTIF Returns Incorrect Value When It Refers to Blank Cells

221075 - 1997: Certain Functions Calculate Differently in Early Versions of Excel

161757 - 1997: Countif Function May Not Work with Blank Cells

162474 - 1997: DFunctions Return Errors When Database Has Too Many Rows

179583 - 1997: EDATE Function May Be Incorrect If Date Is in February

293868 - 1997: EUROCONVERT Function Returns #NAME? Error

026348 - 1997: Err Msg: Error in Formula with More Than 7 Embedded IFs

158687 - 1997: Error When Function Contains a Breakpoint

275534 - 1997: Excel Quits Unexpectedly When You Open Workbook That Contains DDE Link in TRANSPOSE Function

129774 - 1997: FREQUENCY() Returns Zeroes When Entered as Horizontal Array

100790 - 1997: Formula to Count the Number of Rows in Which an Item Appears

061575 - 1997: Formula to Find Number of Weekdays Between Dates

110862 - 1997: Function Wizard Doesnt Enter Formulas as Arrays

111981 - 1997: Functions Not Saved to Quattro Pro File Format

044738 - 1997: Generating a Random Number without RAND() in Excel

100122 - 1997: How to Use the FREQUENCY Function

264851 - 1997: INDIRECT Function Using R1C1 Calculates Incorrectly with Chart Selected

099639 - 1997: LINEST Function Returning Only One Value

096436 - 1997: LINEST or REGRESS Error Value When X-Values Dependent

190810 - 1997: LOOKUP Returns Incorrect Value When Source File Is Closed

141178 - 1997: MOD Function and Mod Operator Return Different Values

087865 - 1997: NORMSDIST

156445 - 1997: New A Functions in Microsoft Excel 97

107564 - 1997: Not All Worksheet Functions Supported as Application

184109 - 1997: OFFSET Accepts Negative Values for Height and Width

129436 - 1997: PERCENTRANK() May Appear to Return Incorrect Results

087862 - 1997: POISSON

076849 - 1997: RATE Differs from HP Calculator for Periods Other than Annual

156841 - 1997: REPT Function Limited to 32767 Characters

166461 - 1997: ROW And COLUMN Functions Are Not Recalculated

186370 - 1997: ROW or COLUMN Formula Is Not Updated After Cut and Paste

086523 - 1997: Random Number Generation

108639 - 1997: Range_Lookup Argument in VLOOKUP() Finds Exact Match

103839 - 1997: Regression Analysis and Best Fit Lines (XE0124)

177051 - 1997: SUBTOTAL May Include Data in Hidden Rows

237188 - 1997: SUMIF COUNTIF COUNTBLANK Return #VALUE! Error

129423 - 1997: SUMIF() Function Fails If Sum_Range Contains Links to Text

192833 - 1997: Sample Code to Use a Date Range with NETWORKDAYS

119148 - 1997: TYPE() Function Doesnt Return Value 8 for Formula

041064 - 1997: Trigonometric Functions Returning Incorrect Values

105955 - 1997: Undocumented ROUNDUP() and ROUNDDOWN() Functions

156926 - 1997: Unusual Behavior When You Use the HYPERLINK Function

269263 - 1997: Update Available for Excel 97 SR-2 REGISTER.ID Function Vulnerability

196791 - 1997: Update Available for Excel CALL Vulnerability

107221 - 1997: Using 'Most Recently Used' Category in Function Wizard

059482 - 1997: Using INDEX and MATCH Against Multiple Criteria

134259 - 1997: VLOOKUP() Returns Incorrect Result

087442 - 1997: VLOOKUP()/HLOOKUP() Return Incorrect Value with TFE or AEE