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.JPG
    excel.JPG
    26.6 KB · Views: 122
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top