If at least 2 of the 3 digits in a cell is the same

I have the numbers from 0-999 (A2-A1000) and have been asked to put a 'yes' next to the numbers which have at least 2 of the 3 digits same in a cell. e.g. 232 has two 2's. I have do show this in the F column from the cell F2-F1000. What is the formula for this?

Nick's picture

Hi Anjana.. Please show your

Hi Anjana.. Please show your appreciation for the previous answer

Adding digits in the same cell

 by thanking your Expert..

Rgds Nick