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
KBSubcategory:

Additional reference words: 3.00 4.00 4.00a



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.