Dear
Please find the below Example here , that i need a Maximum of Number in CHECK-1, that criteria matched with CHECK2 & CHECK-3
ex-
B & A Matched in check 1 & 2 in two places but highest number in check-1 is "3".
Dear
Please find the below Example here , that i need a Maximum of Number in CHECK-1, that criteria matched with CHECK2 & CHECK-3
ex-
B & A Matched in check 1 & 2 in two places but highest number in check-1 is "3".
and the question is? that seems to be the right answer!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
any different formula for that ?
Other option with non-array formula:
=MAX(INDEX(($E$5:$E$21=H5)*($F$5:$F$21=I5)*$D$5:$D$21,))
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks