Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using EXACT to Deduplicate
I want to use the EXACT function to deduplicate multiple real estate ads in
Column I (compare the target cell to every other cell in Column I) of a very large spreadsheet. Once a duplicate is found, I want the macro to look in column B and compare dates, deleting all data in the row with the more recent date, preserving the deduplicated ad in situ in the spreadsheet. This would allow me to know/save the first appearance of an ad and not save its later repetitions. Any help appreciated. Thank you. -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
If you're just trying to delete duplicate rows..........ASAP Utilities
(Excel add-in), has that as one of many features...... available free at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "Darrell Halverson via OfficeKB.com" wrote in message ... I want to use the EXACT function to deduplicate multiple real estate ads in Column I (compare the target cell to every other cell in Column I) of a very large spreadsheet. Once a duplicate is found, I want the macro to look in column B and compare dates, deleting all data in the row with the more recent date, preserving the deduplicated ad in situ in the spreadsheet. This would allow me to know/save the first appearance of an ad and not save its later repetitions. Any help appreciated. Thank you. -- Message posted via http://www.officekb.com |
#3
|
|||
|
|||
Thank you for the suggestion. I downloaded ASAP Utilities and it is,
indeed, loaded with interesting and useful functionalities to leverage Excel. Unfortunately, I found that it has only a "count duplicates" function wherein it identifies duplicates, paints them green and then, chokes on my typical dedupe cell which has 100-200+ characters in many instances. So I am back to looking for some help with the EXACT function to do this job. -- Message posted via http://www.officekb.com |
#4
|
|||
|
|||
Highlight the column, invoke ASAPUtilities "Columns/Rows" "Conditional
Row and column, select, hide or delete" then in the Search Options: choose "duplicate values" and check the "Delete" button.......... Vaya con Dios, Chuck, CABGx3 "Darrell Halverson via OfficeKB.com" wrote in message ... Thank you for the suggestion. I downloaded ASAP Utilities and it is, indeed, loaded with interesting and useful functionalities to leverage Excel. Unfortunately, I found that it has only a "count duplicates" function wherein it identifies duplicates, paints them green and then, chokes on my typical dedupe cell which has 100-200+ characters in many instances. So I am back to looking for some help with the EXACT function to do this job. -- Message posted via http://www.officekb.com |
#5
|
|||
|
|||
Thank you for your more detailed suggestion. It works with simple alpha or
numeric strings, but continues to choke on the more complex alphanumeric strings of a typical 100-200 character real estate ad. I get the following Windows error message: "Run-time error '1004': Unable to get the CountIf property of the WorksheetFunction class." It's also a little buggy in that it appropriates an adjacent column now and then, but rejects the user selecting two columns to dedupe. My spreadsheets are moderately formatted and maybe it doesn't like that either. In any event, when it deletes, it saves "the first duplicate" not necessarily the earliest (date) duplicate which is what I need. Thanks again for you help. I'm going to study up on the EXACT function to see what can be done with that. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Re post the exact formulas | Excel Worksheet Functions | |||
LookUp - Exact only | Excel Worksheet Functions | |||
LookUp - Exact only | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Identifying exact values in alternate rows | Excel Worksheet Functions |