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