how to match multiple columns with multiple rows and count their match

Joined
Jan 31, 2008
Messages
1
Reaction score
0
N1:

A1:F1 compare with H1:M1 and
A1:F1 compare with H2:M2 and
A1:F1 compare with H3:M3 and

then if the max combination in either the rows is 5.. it will output 5...

N2:

A2:F2 compare with H1:M1 and
A2:F2 compare with H2:M2 and
A2:F2 compare with H3:M3 and

then if the max combination in either the rows is 3.. it will output 3...

ive already do this but does work:

N1:

Control+shift+enter, not just enter...

=MMULT(ISNUMBER(MATCH($H$1:$M$4,A1:F1,0))+0,TRANSPOSE(COLUMN($H$1:$M$4)^0))
 

Attachments

  • excel.webp
    excel.webp
    16.5 KB · Views: 129
Last edited:
Back
Top