Required a Formula to find out at least 3 times repeated values in a Single cell

Hi Friends,

I have a large data of employee i want to find out any repeated 3 times repeated values.

if cell A1 has 859587585151185. value should be true bcz it has 85 3 times. my file is attached.

no sir its new question. now i need three same values in a cell. check the file.

Quote from bosco_yip

Or,

it can be shortened to :

=MAX(FREQUENCY(0+MID(A2,ROW(INDIRECT("1:"&LEN(A2))),2),0+MID(A2,ROW(INDIRECT("1:"&LEN(A2))),2)))>=3

Regards

Display More

wow. it works. thanks man you are genius. thanks again.

Quote from bosco_yip

Or,

it can be shortened to :

=MAX(FREQUENCY(0+MID(A2,ROW(INDIRECT("1:"&LEN(A2))),2),0+MID(A2,ROW(INDIRECT("1:"&LEN(A2)))>3

hello there a problem in the formula. it gives true if there are 2 same values 2 times.

etc if in cell a1 are 758575668533 it should not give true bcz there are 2 same values not three 75 and 85 both are 2 times but i want only if one value are 3 times.

Display More

Quote from Carim

It seems to me your question has been answered ...

Can you explain your latest message # 7 ...

that's work but i checked manually in some cells there are only two match value and it gives true. plz check the file row 102