Finding partial duplicate values in the same column

[cmax979]

I have a column of last names with a unique identifier attached to each. Unfortunately, some of the last names were inputed with minor spelling mistakes. As a result, I have entires such as smith 33333 and smth 33333. Is there a formula that I can use to search for the unique identitfer within the column. My data starts at in cell A1 and runs to A2403. Each cell contains the last name and unique identifier. Also, there is a space between name and identifier.

[Richard Buttrey]

Perhaps the simplest approach is to use TextToColumns to split the column into two with the unique identifier now in column B.

Then in C1 copied down use

=COUNTIF(B:B,B1)

then filter column C for values >1

[Richard Buttrey]

@cmax979

So why have you reported my post?

[cmax979]

I didn't report your post. It was a useful response. Do you know how to find the duplicate values? The original formula didn't identify the times the values repeat.

[cmax979]

I meant to reply to your original response. I must have hit report post by mistake. My apologies for the mistake.

[Richard Buttrey]

Hi,

I don't understand. The COUNTIF() function I gave you should do precisely that.