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
Return to index