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.

  • 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

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


    Can you explain your latest message # 7 ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • 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