Hello, I have a list of 8500 names and I want a formula that can identify the cells where the names are the same. I do not have a list of known names that are the same. i.e. I want the formula to tell be James Brown is in cell a20 and c20.
I guess I didn't give an accurate description of the problem. Your solution works great if I have 2 separate columns of names and I am trying to compare names from 1 to the other, but I have column A with a customer number, column B with the customer name. What I am trying to isolate is all the names in column B that are the same but have different customer numbers in column A. What I am trying to do is flag them so I can consolidate all duplicate names under 1 customer number for each set of names that are the same.
Thank you for the suggestion but this seems beyond my level of expertise. Is this a macro? If so do I have to type in all the lines you provided with the same spacing & capitalization. If so are there spaces before and after the = sign and is that a number 1 in front MaxRow?
That works but I got an error message that gave me a debugging option which I selected. It highlights the 4th line which says checkName = Cells(1CurrentRow,2) any suggestions. I think we are close to the finish line.