EXTRACT

Macro Sheets Only

Equivalent to choosing the Extract command from the Data menu in Microsoft Excel version 4.0. Finds database records that match the criteria defined in the criteria range and copies them into a separate extract range.

Syntax

EXTRACT(unique)
EXTRACT?(unique)

Unique is a logical value corresponding to the Unique Records Only check box in the Extract dialog box.

• If unique is TRUE, Microsoft Excel selects the check box and excludes duplicate records from the extract list.
• If unique is FALSE or omitted, Microsoft Excel clears the check box and extracts all records matching the criteria.

Related Functions

DATA.FIND Finds records in a database

SET.CRITERIA Defines the name Criteria for the selected range on the active sheet

SET.DATABASE Defines the name Database for the selected range on the active sheet

SET.EXTRACT Defines the name Extract for the selected range on the active sheet

List of Command-Equivalent Functions