Identifying close or similar match in excel

[muisyoj]

Abel Kemboi	28091156
Abigael Wafula	24684284
Abigael Wafula	24694284
Abraham Bett	14984014
Abraham Bett	23016929
Abraham Bitok	12636549
Abraham Bitok	15274893
Abraham Biwott	11073678
Abraham Biwott	23443920
Abraham Biwott	25373259
Abraham Biwott	25373260

<colgroup><col><col></colgroup><tbody>
</tbody>

Please assist to solve the above issue where i want a formula which will give me close matches of the above ID no. as highlighted.

 

[Stridhan]

how close? how many digits has to be matched?

 

[muisyoj]

how close? how many digits has to be matched?

maximum of 3 digits but i just want i want to maybe identify ID no. maybe similar due to typo error.

 

[Stridhan]

try this formula in conditional formatting

=SUMPRODUCT(--($A$1:$A$11&LEFT($B$1:$B$11,3)=$A1&LEFT($B1,3)))>1