# Finding cell above

#### Bel

##### New Member
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???

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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))

thanks very much

Hi Bel:

see the worksheet simulation ...

the formula used is: =INDEX(A1:B2,1,MATCH(D2,A2:B2,0))
Book1
ABCDE
10100-02001100-1200maxA2:B2TimeFromRow1
25991100-1200
Sheet4
</SPAN>

Regards!

Yogi

Replies
6
Views
293
Replies
7
Views
435
Replies
3
Views
210
Replies
0
Views
386
Replies
23
Views
1K

1,221,521
Messages
6,160,302
Members
451,637
Latest member
hvp2262

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back