Title: What is the purpose of the Row_num argument in the following INDEX function? ... Post by: JohnAmera on Nov 17, 2017 What is the purpose of the Row_num argument in the following INDEX function?
=INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1) A) To return the highest value in the range B2:B5 B) To return the position of the highest value in the range B2:B5 C) To return the column to the left of the highest values in the range B2:B5 D) To return the row of the highest value in the range B2:B5 Title: Re: What is the purpose of the Row_num argument in the following INDEX function? ... Post by: zatan_za on Nov 17, 2017 Content hidden
|