Finding cell above

[Bel]

A couple of weeks ago i asked about how to to display the cell to the left of a cell that contains the maximum of the column of numbers and was given this formula:

INDEX(D7:D30,MATCH(MAX(E7:E30),E7:E30,0),1)

which worked perfectly.

I would now like to know if i can do a similar thing but with rows instead of columns i.e.

A1 = 0100-0200 (time period)
A2 = 5 (number of falls)
B1 = 1100-1200
B2 = 9

I have another cell that displays the max number of falls using this formula:

=MAX(A2:B2)

I would like the cell under the max cell to display the label (time period) that the max occurs i.e. (for this example) it would display 1100-1200.

Is this possible???

 

[Aladin Akyurek]

On 2002-08-25 21:10, Bel wrote:
A couple of weeks ago i asked about how to to display the cell to the left of a cell that contains the maximum of the column of numbers and was given this formula:

INDEX(D7:D30,MATCH(MAX(E7:E30),E7:E30,0),1)

which worked perfectly.

I would now like to know if i can do a similar thing but with rows instead of columns i.e.

A1 = 0100-0200 (time period)
A2 = 5 (number of falls)
B1 = 1100-1200
B2 = 9

I have another cell that displays the max number of falls using this formula:

=MAX(A2:B2)

I would like the cell under the max cell to display the label (time period) that the max occurs i.e. (for this example) it would display 1100-1200.

Is this possible???

Well, it's actually the same kind of formula...

=INDEX(period-range,MATCH(max-cell,fall-range,0))

 

[Bel]

thanks very much

 

[Yogi Anand]

Hi Bel:

see the worksheet simulation ...

the formula used is: =INDEX(A1:B2,1,MATCH(D2,A2:B2,0))

Book1
	A	B	C	D	E
1	0100-0200	1100-1200		maxA2:B2	TimeFromRow1
2	5	9		9	1100-1200
Sheet4

</SPAN>

Regards!

Yogi