Home » Forums » Open Source Learning Center » Question and Answer

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

Submitted by anjana harry on 13 July, 2012 - 01:24

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?

‹ For Each in VBA in Excel open any .bat file with the help of excel button ›
»
Nick's picture

Hi Anjana.. Please show your

Submitted by Nick on 13 July, 2012 - 07:42.

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

Adding digits in the same cell

 by thanking your Expert..

Rgds Nick

»