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.
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.
Hello,
If I am not mistaken ... this new thread is identical to the previous one :
Need any formula or solution if 3 numbers match in a single cell
no sir its new question. now i need three same values in a cell. check the file.
Display MoreMaybe,
In B2, CSE formula (Ctrl+Shift+Enter) copied down :
=MAX(FREQUENCY(MATCH(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),2),MID(A2,ROW(INDIRECT("1:"&LEN(A2))),2),0),ROW(INDIRECT("1:"&LEN(A2)))))>=3
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 MoreOr,
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
wow. it works. thanks man you are genius. thanks again.
Display MoreOr,
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.
It seems to me your question has been answered ...
Can you explain your latest message # 7 ...
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
Don’t have an account yet? Register yourself now and be a part of our community!