Microsoft KB Archive/100939

= 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.