Microsoft Knowledge Base
Excel: EXTRACT() Does Not Clear Unique Records Only Box
Last reviewed: September 12, 1996
Article ID: Q100939
The information in this article applies to:
- Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a
- Microsoft Excel for OS/2, version 3.0
- Microsoft Excel for the Macintosh, versions 3.0, 4.0
Page 142 of the "Function Reference" version 4.0, states that if you omit the unique argument for the EXTRACT() command, Microsoft Excel clears the Unique Records Only check box and extracts all records matching the criteria. This information is incorrect. If you omit the unique argument, Microsoft Excel will use the current setting for the argument.
If you want Microsoft Excel to clear the check box and extract all records matching the criteria, set the unique argument to FALSE, so that the command is: =EXTRACT(FALSE).
This information is also incorrectly stated on page 72 of the "Function Reference," version 3.0.
REFERENCES
"Function Reference", version 4.0, page 142 "Function Reference", version 3.0, pages 72-73
KBCategory: kbdocerr Last reviewed: September 12, 1996 |