Comparing multiple rows with columns in Excel

[Shan11]

I wanted to compare the alphabets with 4 columns for every 4 rows. For example,


A = [aabc;dbba;a]
B = [aabc;baba;c]
C = [aabc;dbba;b]
D = [bcac;bcbc;a]

[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]4 vs 4[/TD]
[TD]1 Cell Up[/TD]
[TD]2 Cell Up[/TD]
[TD]1 Cell Down[/TD]
[TD]2 Cell Down[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]c[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]b[/TD]
[TD]b[/TD]
[TD]b[/TD]
[TD]a[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]c[/TD]
[TD]c[/TD]
[TD]c[/TD]
[TD]c[/TD]
[TD]aabc[/TD]
[TD]abcd[/TD]
[TD]bcdb[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]d[/TD]
[TD]b[/TD]
[TD]d[/TD]
[TD]b[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]b[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]b[/TD]
[TD]b[/TD]
[TD]b[/TD]
[TD]b[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]c[/TD]
[TD]dbba[/TD]
[TD][/TD]
[TD]baac[/TD]
[TD][/TD]
[TD]bcdb[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]a[/TD]
[TD]c[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]c[/TD]
[TD]c[/TD]
[TD]c[/TD]
[TD]c[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]c[/TD]
[TD]a[/TD]
[TD]c[/TD]
[TD]c[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]a[/TD]
[TD]acca[/TD]
[TD]ccab[/TD]
[TD]caab[/TD]
[TD]aacc[/TD]
[TD]baac[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]b[/TD]
[TD]b[/TD]
[TD]b[/TD]
[TD]b[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]b[/TD]
[TD]b[/TD]
[TD]b[/TD]
[TD]a[/TD]
[TD]bb[/TD]
[TD]ab[/TD]
[TD]cab[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]






A,B,C,D are the columns, `aabcdbbaa` so on are the rows.These are the input. The following columns are the matching results of A,B,C,D columns as output.


If we look at the table above shows first four rows, `"aabc"` repeated in 3 columns. So, out of 4, 3 gets correct matching.it is 3/4. for the second cycle, we can see `"dbba"` repeated so it 2/4.This is for 4 rows vs 4 rows, now the same matching method for taking one line down, two line down and three line down comparing with other string. Means, the rows will be constant and just the alphabets changing.
Is there any formula available in excel to get such output? The sample of the out has been provided in the table.