Since you want to include more columns that you're filtering on (a single column
for uniqueness), you don't want to copy to another location using that dialog.

You have to use a multiple step process.

On the other hand, if you wanted to copy the entire range (single column or
multiple columns to determine uniqueness), you can start the dialog on the new
sheet.

Then go back to the real data when you're entering addresses into that dialog.

Seems kind of backward, but it works fine.

I don't know if xl2007 changed this "feature".



Stefi wrote:

Thanks, Dave, I did that, it worked, but it shows that Copying unique records
to a new location feature doesn't work in Excel2003. I wonder has it been
fixed in Excel2007.

Stefi

€žDave Peterson€� ezt Ã*rta:

Don't use the criteria range (leave it empty).
Do the advanced filter against a single column A1:a14
Make sure unique records is checked.

After the filtering is done, select both columns.
(F5, ctrl-g, edit|goto)
Special|visible cells only

Copy those visible cells (now including both columns)

paste into the new location



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

--

Dave Peterson


--

Dave Peterson