VBA to find duplicate value in a string across entire row and delete one duplicate

Hey Joske920, thanks for your reply, I thought about deleting the farthest to the right cell out of the two duplicate valued cells to show the expected result but then realized that would not be good for you guys because the "argument" would no longer exist, so that is why i kept both duplicates specifically in Row 11 and tried to explain in great detail the reasoning and expected end result in the description box... Hope that makes sense and helps?

Joske920, If you take just one row and pretend that is the only row on the entire sheet with what I need accomplished, may help. anytime there are two or more strings that have a duplicate value in the 3rd position of each string, which ever cell that contains the duplicate, the one farthest to the right in the row gets deleted / clear contents. Hopefully that sounds more descriptive..?

But in the case of row 7 and row 10, all of the strings have duplicates in the 3rd position. In that case, as in my description boxes on the attached worksheet, the entire row will be empty because there are no other strings of data in the row that contain unique values...

Thanks Joske920, trying it as we speak... it is definitely taking a while to process but will let you know when it finishes it's process...

Joske920...

So it is very close... I have yellow highlighted cells that the VBA should NOT have deleted for illustration purposes and yellow highlighted the explanation box that
hopefully clarify's the end result... As you can see in the attached spread sheet after the VBA ran, it worked perfect in removing duplicates (when found from the 3rd position),
the only thing is it deleted BOTH strings, i need it to delete only 1 of the 2 that has the duplicate so what we are left with are two strings which both have unique
values in them... The sheet is now in the state you asked for at the beginning of this thread. (an example of what the finished result should look like) So the cells
highlighted in yellow should not have been deleted...

Joske920,

Before the VBA runs, there are alot of rows with three stings in them, when the VBA finishes, only two should remain and both of those remaining should be unique to each other... I think you asked the question prior, if 2 have duplicates and only 1 gets deleted....which one does VBA choose to delete from the row? Answer: always the duplicate farthest to the right side of the spread sheet>>

Please Login or Register  to view this content.

....? copy paste, all of this? and where do I paste it exactly? i know nothing about VBA... Ugh!

All rows with duplicates are deleting perfectly... so technically "SOLVED"... I have to do a count with a regular formula (which i can handle that myself) but the rows that have just one string in them remained after I just ran that last VBA and after pasting the ' in front of that code you advised.... Must be the first 5 rows (5 thru 10) are left with just one string because the VBA was only looking for strings with duplicates in the 3rd position and deleting only one of the duplicate strings... so i guess it makes sense that the VBA would not check to see if any given row had only 1 string to begin with. I can try to figure something out to delete the entire row if only 1 string is found, as i need to calculate rows with 2 strings that are unique values... but thank you so much for your professional and fast assistance!! Awesome work!! I very much appreciate your help!!

Joske920. Perfect, works like a champ! Thank you very much! awesome work...