- 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))
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
Last edited: