Match and Tables
Thank you. I used your formula and it worked out fine.
Jan
vezerid wrote:
MATCH only operates on 1D vectors. C22:H33 is 2D.
=SUMPRODUCT((ROW(C22:H33)-ROW(C22)+1)*(C22:H33=MAX(C22:H33)))
This formula will work correctly only if MAX will appear only once in
the data.
HTH
Kostis Vezerides
On Nov 11, 2:31 pm, wrote:
Can anybody tell me what to do:
I have a calculated table {=TABLE(B6,C6)} in cells C22:H33 and use
this formula:
=MATCH(MAX(C22:H33),C22:H33) but it alwys returns N/A.
Is there another way to get the row number for the cell, containing
the maximum value?
Jan
|