delete all duplicate

Thank you for your help. I apologize for not having valid code, but I cannot seem to get my head around this problem's solution. I am trying to determine a way to check each number in column B verses all of column C. I believe I must loop within a loop to scan the 500 rows of Column C for each...

Hi, I need a macro that will take information from a UserForm, search a sheet for duplicate entry (PRI number). If duplicate rows are found, they are deleted and the new information from the UserForm inserted onto the sheet. this is my present coding Private Sub CmdAdd_Click() Dim iRow As...

Ok once again I'd like to thank everyone for their much appreciated help on the last question. Now I have a list of numbers many which are duplicates what formula would I use to delete the duplicates? <colgroup><col></colgroup><tbody> 32245392975 32245392975 32367684391...

Hi, I'm a little stuck!! I would like to delete rows based on duplicated text values (names) in column B. The end result would show all individual rows in the spreadsheet with no duplications in column B.

I am trying to do an unique data base to add to. I Do not want to just delete the duplicate, but both, or all three duplicates. for example I start with Ken Ken Mark Mark Ann I need the result to only have Ann I have already tried the advanced filter and checking the box unique records...