Just select a single column, the column you want to filter on.

Biff

"crcurrie" wrote in message
...
Thanks, Dave -- I created the concatenated column but I'm still not having
success.

These are the steps I'm taking:

1. Select all 20 columns of the worksheet.
2. Click on Advanced Filter.
3. Click on "Filter the list, in place."
4. Leave the list range as the all the cells in the spreadsheet.
5. Select the concatenated column as the Criteria range.
6. Click on "unique records only."
7. Click OK.

Am I doing something wrong?


"Dave F" wrote:

Create a helper column which is a concatenation of the four columns;
i.e.,
=CONCATENATE(A1,B1,C1,D1) etc and run the unique records filter on that.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"crcurrie" wrote:

I can't seem to get the filter for unique records to work. I have a
spreadsheet with about 20 columns and about 3000 rows. I want to
filter on
mailing addresses, which is four columns. If I create a
separate worksheet containing data only from the columns I want to
filter for
the unique records, and then choose Advanced Filter, and the list range
and
criteria range are the same, and click "Unique Records Only", it works.
But
if I try to filter the complete worksheet with all 20 columns, and set
up the
filtered columns as the criteria and all the columns as the list range,
it
just gives me back the same set of rows, including duplicates.

What am I doing wrong?