Hi Abassi,

Sounds like maybe one of your columns is a formula returning
a result. Try selecting the column with the formula, copy it
and Paste SpecialValues in place. That will convert
your formulae to values.

Does Advanced Filter behave properly now?

HTH
Martin


"Abbasi" wrote in message
...
Hi everyone!

When I use Advanced Filter to filter out Unique records and copy them to a
new location, it copies only the first record and only the first column of
the data.

I tried with the heading-row included and excluded but the result doesn't
change.

When I apply the same strategy to another worksheet with the same headings
but different data, it reports an error "The extract range has a missing
or
illegal field name".

I think, I am not complying with some requirements of the feature.

Please help me, in a bit detail, so as to get me out of this problem.
--
Technical User