Thanks for the steps. I did them to the letter, but received an error on the
second record (I'm assuming second, since it copied the first, then failed).
The error received was:

"The extract range has a missing or illegal field name."

Suggestions?
--
Dawg House Inc.
"We live in it, therefore, we know it!"


"Aladin Akyurek" wrote:

1. In F1 enter: XLoc
2. In F2 enter:

=ISNA(MATCH(C2,ClosedLocations,0))

3. Select A1:E450.
4. Activate Data|Filter|Advanced Filter.
5. Check the option: Copy to another location.
6. Enter $A$1:$E$450 for List range.
7. Enter $F$1:$F$2 for Criteria range.
8. Enter $F$3 for Copy to.
9. Leave unchecked the option: Unique records only.
Click OK.

Dawg House Inc wrote:
Thanks for your help, but I'm not sure I follow it.

I have A$1$:E$:450 filled with records.
I have Col C labeled "Location"
In Col J, I have a 5-record listing named "ClosedLocations" (J1:J5)

I don't know if I understand what you're suggesting I do with the F2:F3 info
nor do I follow the "then run Advanced Filter on the data area".

The Adv Filter is looking for:

List Range: A2:E451 (A1:E1 are row headers)
Criteria Range: ???? Is this where you're suggesting I put the ISNA function?

Still confused....
House