Advanced Filter Issue

A

Abbasi

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.
 
M

MartinW

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 Special>Values in place. That will convert
your formulae to values.

Does Advanced Filter behave properly now?

HTH
Martin
 
A

Abbasi

You are right, Martin. I have formulae in some columns. The error message is
very much mis-leading keeping the Fieldnames in focus.

Anyhow, thank you very much and have a very good time
 
M

MartinW

Yes, you are right about the error messages. Excel
is a fantastic program but there are many parts to it
that make me want to throttle it's creators. <bg>

Glad it worked out,
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top