I have a need to look for duplicate entries in an Excel worksheet and delete the ones with outdated or incomplete data. This has proven to be a bit more difficult than I thought it would be. I will be working on a better solution for this based on demand. The AbleBits add on did a better job than the other stuff I found but still was not what I desired. I’ll be updating this as I find more information.
References:
http://stackoverflow.com/questions/15754501/combining-duplicate-entries-with-unique-data-in-excel
http://www.ablebits.com/excel-combine-rows/index.php