HI Excel Hero!
I am using this formula to count repetition of 2 numbers in a single cell at least 3 times, but some time it gives wrong result i want to know why it gives wrong result? What is best solution to avoid wrong result.
Formula that i am using is
=MAX(FREQUENCY(0+MID(A1,ROW(INDIRECT("1:"&LEN(A1))),2),0+MID(A1,ROW(INDIRECT("1:"&LEN(A1))),2)))>=3
see attachment