Hi,
I am working with the below table, I need to get 2 things, the row number of the max value in C, and the value of column B.
<tbody>
</tbody>
I am using the below formula in G2 to return the max value of an array,
however if i try
i get an error.
Thanks.
I am working with the below table, I need to get 2 things, the row number of the max value in C, and the value of column B.
A | B | C | D | E | F | G | H | ||
<colgroup><col width="92"></colgroup><tbody> </tbody> | a | 0 | 505953841882 | ||||||
<colgroup><col width="92"></colgroup><tbody> </tbody> | b | 200 |
<colgroup><col width="92"></colgroup><tbody> </tbody> | ||||||
<colgroup><col width="92"></colgroup><tbody> </tbody> | c | 0 | |||||||
<colgroup><col width="92"></colgroup><tbody> </tbody> | d | 0 | |||||||
<colgroup><col width="92"></colgroup><tbody> </tbody> | e | 0 | |||||||
<colgroup><col width="92"></colgroup><tbody> </tbody> | f | 0 | |||||||
<colgroup><col width="92"></colgroup><tbody> </tbody> | g | 500 |
<tbody>
</tbody>
I am using the below formula in G2 to return the max value of an array,
Code:
{=MAX(IF(A:A=F2,C:C))}
Code:
{=ROW(MAX(IF(A:A=F2,C:C)))}
Thanks.