filtering for unique records

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
No, you don't need to specify a criteria range. You can extract unique
values from the entire list.
 
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? :-(
 
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!!!
 
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?
 
Are you selecting the destination sheet, before you choose
Data>Filter>Advanced Filter>
 
Back
Top