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