| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract duplicate rows to another worksheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too Many Rows For Worksheet | New Users to Excel | |||
| Too Many Rows For Worksheet | New Users to Excel | |||
| XLS Worksheet 'Select All' button + top 2 rows not in view in wind | Excel Discussion (Misc queries) | |||
| copy rows meeting criteria to another worksheet | Excel Worksheet Functions | |||
| In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
Threaded Mode
