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