I need a macro to search a field and delete duplicates. In my spreadsheet there may be duplicates of ID, First Name & Last Name. I have created a field to group these together so that I can find duplicates but how can I get excel to find and delete these leaving only one of the duplicates?

Thanks