Match and Tables
I used vezerid's formula, but thanks anyway.
Jan
Ashish Mathur wrote:
Hi,
Assuming this is the data in the range D5:E10
1 45
2 67
3 878
10 12
5 23
6 1
In F5, enter the following array formula
=IF(OR(D5:E5=MAX($D$5:$E$10)),MAX(D5:E5),""). Copy this formula down
to F10.
IN cell F12, enter the following formula
=MATCH(MAX(D5:E10),F5:F10,0)+COUNTBLANK($F$1:F4)
wrote in message
...
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
|