<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Range | Formula =(LEN(C2)-LEN(SUBSTITUTE(UPPER(C2),UPPER(A2),"")))/LEN(A2) | Accurate Result | |
A@abc.com | A@abc.com.sg/connection lost, A@abc.com.sg/connection lost, AA@abc.com.sg/unknown, A@abc.com/error | 4 | wrong, should be 1 |
bb@mail.com.sg | bb@gmail.com.sg/connection lost, aa@mail.com.sg/connection lost, bb@mail.com/error | 0 | correct |
ab@outlook.com | aab@outlook.com/connection lost, aab@outlook.com.my/connection lost, ab@outlook.my/connection lost | 2 | wrong, should be 0 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>