Extract Command in Excel 1
 

The 1985-7 version of Excel had a command "Extract" (I remember it, and
besides I have the manual). You set up "Database" and "Criteria" Areas, and
the command copied the records in the "Database" that met the criteria to the
area under the "Criteria." There was also a macro command "Extract," which
is what I really want to use. What is the name of the command in the 2003
version of Excel, and where is it? (I am using the Japanese version of Mac
2004 Excel, but I can probably figure it out if I have the English and the
place.)

MacXL1!

Take a look at "Database Functions" and "Advanced Filter" in XL Help.

DGET will "extract" 1 record. Advanced Filter can extract many.

For more on Advanced Filter, see

http://www.contextures.com/xladvfilter01.html



In article ,
"Bethetsu" wrote:

The 1985-7 version of Excel had a command "Extract" (I remember it, and
besides I have the manual). You set up "Database" and "Criteria" Areas, and
the command copied the records in the "Database" that met the criteria to the
area under the "Criteria." There was also a macro command "Extract," which
is what I really want to use. What is the name of the command in the 2003
version of Excel, and where is it? (I am using the Japanese version of Mac
2004 Excel, but I can probably figure it out if I have the English and the
place.)