Hello group! In a earlier post I had sought help trying to delete any duplicate info if there was a duplicate number in column V and have it delete the last entry row. With help from this site I was able to get that to work. The problem that I've since discovered is that I need to really look at the duplicate numbers to see what row of the duplicates that I would prefer to keep before deleting any of them; due to content entry if slightly different, etc. Thus my new request for help!
What I'd like to do is have help with the following code or new code if possible which will allow me to identify the duplicate numbers in column "V" and have them appear in a message window. The code would search the entire column of data and afterwards pop up a message window that would say something to the effect "The following complaint #'s have duplicate entries: 454,462,527,..." etc.
Then I would be able to manually filter those numbers and delete the row(s) I choose.
The following code currently identifies the number of duplicate entries in column "V" and deletes the 2nd entry in Column "V" only (not the entire row). Afterwards a message window will appear notifying me something to the effect "There were 10 duplicate entries deleted". Would anyone be able to help modify this code to just identify the duplicate entry numbers instead of deleting anything?
Any help would be appreciated.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks