Thanks Sean, but with your settings nothing happens. LIST range has to be
$A$1:$A$14, and CRITERIA range has to be $A$1:$B$14 to make a correct
filtering in-place (I also thought it should be the opposite way like you
wrote, that's why I posted 2nd part of my question).

What is a bigger problem, copying to another location doesn't work even with
the above settings. Why?

Regards,
Stefi


€žSean Timmons€� ezt Ã*rta:

Should work if you do as you assumed you should.

List Range should be $A$1:$B$14. Criteria range should be $A$1:$A$14 if
column A has your duplicate records. Otherwise, make it $B$1:$B$14

Assuming you are selecting Unique records and you are attempting the paste
to another place in the same worksheet.

"Stefi" wrote:

Hi All,

I'd like to make a simple filter for unique records copied to another
location.

The layout is this: two columns, A:B, 14 rows including a header. Unique
filter is to be made by column A, but I want to copy both columns to a new
location.

When in the advanced filter dialog
List range: $A$1:$A$14
criteria range: $A$1:$B$14
then in-place filtering is correct, but I can't in any way achieve the
filtered range copied to another location, say C1.

Any ideas?

Another question is that why List range has to be $A$1:$A$14 (the volumn by
which uniqueness is checked)? For me calling this range criteria range should
be more logical, and range $A$1:$B$14 should be called List range (cells I
want to list in another place).

Maybe I misunderstand something not being a native English speaker, please
explain me the correct usage of filtering unique records!

Thanks,
Stefi