Question

match laumn a with colume be​

Answer 1

Answer:

ok

BTW where are they ???

are they on the way ???

he he he he he he..... xD

Answer 2

Answer:

Brainiest me

Explanation:

You need to specify that your two columns start at row 1 (with a $ absolute reference), and end at the row above the current row (with a relative reference). Like so: =MAX(IF(B$1: B1=B2, C$1:C,")) Although I would say something other than an array formula is likely preferable. Note also that it is unwise to use an Array formula over the entire length of a column, circular reference, or no [Array formulas are more intensive, basically, so calculate too slow on such a large area].