filtering for unique records

G

Guest

When using Excel's Advanced Filtering utility to copy unique records to a
different location, does one need to specify a criteria range or is the
selection "unique records only" self evident?
 
D

Debra Dalgleish

No, you don't need to specify a criteria range. You can extract unique
values from the entire list.
 
G

Guest

Debra, right after I posted my question, it occurred to me that I should have
checked your website first. I did go there eventually and read the segment
about extracting data to another worksheet (which is I what I would like to
do). However, even though I follow your directions (at least I think I do!),
I get the message that filtered data can only be copied to the active sheet.
Where might I be going wrong? :-(
 
G

Guest

Debra, I had missed the point about starting the Advanced Filter from the
sheet where I want the results. Once I did that, it worked perfectly.
Thanks!!!
 
G

Guest

Debra,

I have followed your instructions, however I still get the same message
about an active worksheet. Does it matter if there are empty rows in my
database?
 
D

Debra Dalgleish

Are you selecting the destination sheet, before you choose
Data>Filter>Advanced Filter>
 

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

Top