Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Articles for product: Microsoft Excel 2000 Standard Edition

Article ID Article Title Hidden
214069 XL: How to Return the First or Last Match in an Array
214070 Description of filtering and extracting a record that contains a text string in Excel
214072 XL2000: Algorithm Used for QUARTILE() Function
214074 XL2000: Cannot Start or Change Protected Objects
214075 XL2000: How Chart Axis Limits Are Determined
214079 XL2000: Formula to Count the Number of Rows in Which an Item Appears
214082 XL2000: LINEST Function Returns Only One Value
214084 XL: How to Display the File Name of a Worksheet Without Using a Macro
214088 XL2000: Error Message: Cannot Open Consolidation Source File
214089 XL: Custom Number Formats Are Lost When Worksheet Saved As Lotus 1-2-3 File
214090 HOW TO: Use RAND() to Generate Randomly Distributed Integers in Excel 2000
214091 XL: Finding the Balance of a Loan for a Given Period
214092 XL2000: Lotus 1-2-3 WK1 File Loses Formatting When Opened in Excel
214093 XL: How to Display the Current Date and Time with Text
214095 HOW TO: Modify a Particular Time with the TIME and MOD Functions in Excel 2000
214098 Error Message when you use the Fourier Analysis tool in Microsoft Excel: "Fourier Analysis - The Number of Input Values Must Be 4096 or Less"
214099 How to work with serial number dates and Julian dates in Excel 2000
214100 XL: How to Extract an Exact Match of Text from a Database
214102 XL2000: Regression Tool Error if There Are More Than 16 X Ranges
214103 XL2000: Cells Made Blank with Quotation Marks Act As Text Cells
214108 XL: "Cannot Open Protected File" Error Message When You Open Password Protected WK3 or WK4 File
214111 XL2000: ATP Definition: NORMSDIST
214113 XL: Function to Compute Interest and Growth Rate on a Single Payment
214114 Unexpected result pasting non-contiguous range from Excel into Word
214115 XL2000: Solver Uses Generalized Reduced Gradient Algorithm
214117 XL2000: Using Noncontiguous Ranges in Array Functions
214119 How to create charts with multiple groups of stacked bars in Excel 2000
214122 XL2000: Converting a Decimal Number to hh:mm:ss Format in Excel
214125 XL2000: Converting Hours in Decimal Form to HH:MM:SS Format
214127 How to remove links from a worksheet in Excel 2000
214131 XL2000: Excel Fields May Save Incorrectly in dBASE Formats (.*dbf)
214133 XL: Formula for Distance/Velocity Returned in Hours, Minutes, and Seconds
214139 XL2000: How to Break Links Between a Chart and a Worksheet
214141 XL2000: Formula to Find Number of Weekdays Between Dates
214149 XL2000: Keeping a Cumulative Total in a Column or Row
214154 XL2000: Error Message with Formula Containing More Than Seven Embedded IF Statements
214232 XL2000: Chart Labels Print Inside a White Box
214237 XL2000: Using Excel 2000 Files with Earlier Versions of Excel
214239 XL2000: Sheet Protection Does Not Disable Options Settings
214240 XL2000: Glossary of Charting Terminology
214241 XL2000: Formula for Cumulative Category Total
214243 XL2000: External Link Is Not Updated When Source Cell Is Moved
214246 How to use the Template Wizard with the Data Tracking add-in in Excel 2000
214247 HOW TO: Hide Records with Duplicate Cell Entries in Excel 2000
214248 XL2000: How to Force Macro Code to Wait for Outside Procedure
214249 How to use the Conditional Sum Wizard in Microsoft Excel
214250 Excel cannot open MultiPlan files
214251 HOW TO: Use the INDEX and LINEST Functions to Solve for New X-Values in Excel 2000
214252 HOW TO: Use the Excel Lookup Wizard (Lookup.xla) in Excel 2000
214253 How to link to data in a file that is damaged in Excel 2000