I have a column that contains the following values:
BCDEABCDE BCDEABCDEA ABCDEABCDE A*CBAAECCE ABC EA*CDE
how do I take the first Row value "BCDEABCDE " and compare it with each remaining row to get some values such as(the total matched number, the total unmatched number?
For example, if i compare the first row"BCDEABCDE " with the second row,which is empty,
the total matched number = 0
the total unmatched number = 10