Hi folks,
need a macro or function that will recognize a duplicate and take a value from the last duplicate add it next to the first and delete extra duplicates.
there could be 2, 3 0r 4 duplicates
ie
Column A Column B Column C
REGO START DATE END DATE
EFG001 01/08/12 07/08/12
EFG001 08/08/12 18/08/12
I would like this left
EFG001 01/08/12 18/08/12
Bookmarks