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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505953841882
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]a
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD]505953841882
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505953841882[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]b
[/TD]
[TD]200
[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505424741852[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505953841882[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]c
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505953841882[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]d
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505424741852[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]e
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505424741852[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]f
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505424741852[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]g
[/TD]
[TD]500
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505953841882
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]a
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD]505953841882
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505953841882[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]b
[/TD]
[TD]200
[/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505424741852[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505953841882[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]c
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505953841882[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]d
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505424741852[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]e
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505424741852[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]f
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 92"]
<colgroup><col width="92"></colgroup><tbody>[TR]
[TD="width: 92"]505424741852[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]g
[/TD]
[TD]500
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.