Ooops!

Criteria should be:
=AND(B2="F",C227)

Should be:

=AND(B2="F",C226)

Biff

"T. Valko" wrote in message
...
You must have the criteria set incorrectly.

Assume:

A1:C1 = column headers = name, sex, age
A2:An = names
B2:Bn = sex = F or M
C2:Cn = age as a number

Criteria should be:

=AND(B2="F",C227)

Assume you want this data extracted to an area starting in cell H1.

Enter the criteria formula in F2.

Select cell A1
Goto DataFilterAdvanced filter
Copy to another location
List range should already be selected
Criteria range: F1:F2
Copy to: H1
OK

Biff

"karen" wrote in message
...
how do I extract records on a worksheet showing all female employees who
are
older than 26. I have a criteria and an extract area set up on the
worksheet.
When I go to Data, Filter, then Advanced Filter, I then click on Copy to
another location. I put in my information but it lists everyone including
the
males.