View Single Post
  #1   Report Post  
Darrell Halverson via OfficeKB.com
 
Posts: n/a
Default 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