Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |