| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding muliple duplicate records in spreadsheet
Advanced filter isn't the answer (I think)
Duplicate Row issue 5 Columns -- ECode, JCode, ECode, PPHrs, PPDate. I will sometimes have several entries (updates) to the ECode, PPDate, and PPHrs for some records. I need to compare the five columns for duplicates and post the records with the greatest hours for the ECode, ECode, and PPDate ECode JCode ECode PPHrs PPDate 54511 003690 027 1 01/09/09 54511 003690 027 3.5 01/09/09 54511 003690 027 11 01/09/09 54511 003690 027 16 01/23/09 54511 003690 027 8 02/20/09 54511 003690 027 8 02/20/09 54511 003690 027 12 02/20/09 54511 003690 027 16 03/06/09 54511 003690 027 8 03/20/09 54511 003690 027 16 03/20/09 54511 003690 027 40 03/20/09 54511 003690 027 5 04/03/09 54511 003690 027 5 05/01/09 54511 003690 032 8 03/20/09 54511 003690 837 24 02/06/09 I need to keep the highlighted rows and delete the other rows €“ or copy them to another worksheet. The spreadsheet has about 16000 rows and 12 columns, but these are the columns I need to work with.. Thanks in advance.. (PC, xcel 03) ShagNasty€¦ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding duplicate records that are not exact matches but very clos | Excel Discussion (Misc queries) | |||
| Finding duplicate records | Excel Worksheet Functions | |||
| Finding duplicate numbers in a spreadsheet | Excel Worksheet Functions | |||
| Finding duplicate records in multiple worksheets | Excel Discussion (Misc queries) | |||
| Finding duplicate records in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
