Here's an approach pulls the unique records onto another sheet:

Assumptions:
Sheet1 contains your data in cells A1:C1000
Sheet2 is where you want the extracted unique data to be displayed

Using Sheet2:
A1: LastName
B1: FirstName
C1: Address

InsertNameDefine
Names in workbook: Sheet2!Extract
Refers to: =Sheet2!$A$1:$C$1

Still using Sheet2:
InsertNameDefine
Names in workbook: Sheet2!Database
Refers to: =Sheet1!$A$1:$C$1000

(Notice: you are on Sheet2, and creating a Sheet2-level range name, but
the referenced range is on Sheet1)

The reason: An advanced filter cannot SEND data to another sheet, but
it can PULL data FROM another sheet.

Now...set up the Advanced Data Filter:
<Data<Filter<Advanced Filter
Select: Copy to another location
List Range: (press F3 and select Database)
Criteria Range: (none for this exercise)
Copy To: (press F3 and select Extract)
Check: Unique records only
Click [OK]

Note: if you want to run that Advanced Data Filter again,
you'll need to re-select the range "Database" each time

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Northwoods" wrote:

I have a client history that includes similar (Name, address) and dissimilar
(date) information. I want to extract duplicate records to another worksheet
and leave only 1 record per client on the other. Problem is querying only the
first 3 columns, LastName, FirstName & Address and ignoring the remaining 3
columns that have dissimilar information and the system would consider unique.
There are 22,000 records.
Any ideas most appreciated