Darrell Halverson via OfficeKB.com
Guest
Re: Using EXACT to Deduplicate
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
Bookmarks