How do I create a code that will count each time the matching value in F1022:F1035 precedes a matching value in G1021:T1021 from F1011:Y1011 and record in the G1022:T1035 on the same row as the match in F1022:F1035 and the same column as the match in G1022:T1035.
example
If F1011:Y1011=7,6,5,11,5,5,4,6,10,7,9,6,6,4,5,10,5,9,6,5
If F1022:F1035=1,2,3,4,5,6,7,8,9,10,11,12,13,14
If G1021:T1021=1,2,3,4,5,6,7,8,9,10,11,12,13,14
Partial results in G1022:T1035
L1028=1, because f1011=7,g1011=6 and f1028=7, L1021=6,
this match occurred once in the range F1011:Y1011 and
result is recorded on row 1028 and column L
K1027=2, because G1011=6,H1011=5 & X1011=6,Y1011=5 and f1027=6, K1021=5,
this match occurred twice in the range F1011:Y1011 and
result is recprded on row 1027 and column K
example
If F1011:Y1011=7,6,5,11,5,5,4,6,10,7,9,6,6,4,5,10,5,9,6,5
If F1022:F1035=1,2,3,4,5,6,7,8,9,10,11,12,13,14
If G1021:T1021=1,2,3,4,5,6,7,8,9,10,11,12,13,14
Partial results in G1022:T1035
L1028=1, because f1011=7,g1011=6 and f1028=7, L1021=6,
this match occurred once in the range F1011:Y1011 and
result is recorded on row 1028 and column L
K1027=2, because G1011=6,H1011=5 & X1011=6,Y1011=5 and f1027=6, K1021=5,
this match occurred twice in the range F1011:Y1011 and
result is recprded on row 1027 and column K