Experts. I've been searching for a piece of vba code that will work to clear duplicates in a column in excel using vba. I found something that works if the values I want to search for are numerical. I can't seem to find anything that works for text fields.
Attached is a screen shot of the sheet. I will have multiple partners listed. They can be listed x number of time. I would like to show the first one in the group and clear the cells where the name is repeated. Then show the next partner and clear the cells where that name is repeated.
Any ideas? Thank you!!